-
Notifications
You must be signed in to change notification settings - Fork 3
postgres pgload
ghdrako edited this page Feb 29, 2024
·
1 revision
load csv
from /tmp/geonames/allCountries.txt
into pgsql://appdev@/appdev
target table raw.geonames
with fields terminated by '\t',
fields optionally enclosed by '§',
fields escaped by '%',
truncate;
Test