Re: OT: help with pgloader

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