mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-06 22:37:02 +02:00
24 lines
392 B
Fish
24 lines
392 B
Fish
load csv
|
|
from inline
|
|
into postgres:///pgloader?tablename=pkey
|
|
|
|
with fields not enclosed,
|
|
workers=32,
|
|
concurrency=8,
|
|
fields terminated by '\t'
|
|
set work_mem to '1024 MB',
|
|
maintenance_work_mem to '2048 MB'
|
|
|
|
before load do
|
|
$$ drop table if exists pkey; $$,
|
|
$$ create table pkey(id int primary key ,name varchar(100)); $$;
|
|
|
|
|
|
1 1
|
|
2 2
|
|
3 3
|
|
3 3
|
|
4
|
|
5 5
|
|
6 6
|