On 2024-07-10 00:36 +0200, Sbob wrote: > 4) created a copy.load file that looks like this: > > $ cat copy.load > LOAD COPY > FROM copy://./pgbench_accounts3.dat > INTO postgresql://localhost/postgres > TARGET TABLE public.pgbench_accounts > WITH delimiter '|' > > > However pgloader bombs on the delimiter (see below) > > $ pgloader copy.load > 2024-07-09T23:26:21.005000+01:00 LOG pgloader version "3.6.7~devel" > 2024-07-09T23:26:21.006000+01:00 LOG Data errors in '/tmp/pgloader/' > 2024-07-09T23:26:21.006000+01:00 LOG Parsing commands from file > #P"/var/lib/pgsql/copy/copy.load" > KABOOM! > ESRAP-PARSE-ERROR: At > > TARGET TABLE public.pgbench_accounts > WITH delimiter '|' > > ^ (Line 5, Column 19, Position 141) You're missing the terminating semicolon. -- Erik
