mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-07 14:56:59 +02:00
10 lines
286 B
Fish
10 lines
286 B
Fish
LOAD CSV
|
|
FROM '/Users/dim/dev/CL/pgloader/galaxya/yagoa/communaute_profil.csv'
|
|
INTO postgresql://dim@localhost:54393/yagoa?communaute_profil
|
|
|
|
WITH truncate,
|
|
fields not enclosed,
|
|
fields terminated by '\t'
|
|
|
|
SET work_mem to '32 MB', maintenance_work_mem to '64 MB';
|