| From: | Erik Wienhold <ewie(at)ewie(dot)name> |
|---|---|
| To: | Sbob <sbob(at)quadratum-braccas(dot)com> |
| Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: OT: help with pgloader |
| Date: | 2024-07-09 23:47:26 |
| Message-ID: | 746bb786-1616-4243-8705-653a45fc1f94@ewie.name |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wasim Devale | 2024-07-11 08:15:38 | indexes on partitioned tables |
| Previous Message | Sbob | 2024-07-09 22:36:33 | OT: help with pgloader |