pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: Erik Wienhold <ewie@ewie.name>
To: Sbob <sbob@quadratum-braccas.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: OT: help with pgloader
Date: Wed, 10 Jul 2024 01:47:26 +0200
Message-ID: <746bb786-1616-4243-8705-653a45fc1f94@ewie.name> (raw)
In-Reply-To: <85b3aab6-91ef-496e-88d5-047f170e1a06@quadratum-braccas.com>
References: <85b3aab6-91ef-496e-88d5-047f170e1a06@quadratum-braccas.com>
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
view thread (2+ messages)
Message-ID: <746bb786-1616-4243-8705-653a45fc1f94@ewie.name>
Permalink: ../746bb786-1616-4243-8705-653a45fc1f94@ewie.name/
Also on: postgresql.org/message-id/746bb786-1616-4243-8705-653a45fc1f94@ewie.name
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ewie@ewie.name, sbob@quadratum-braccas.com, pgsql-admin@lists.postgresql.org
Subject: Re: OT: help with pgloader
In-Reply-To: <746bb786-1616-4243-8705-653a45fc1f94@ewie.name>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox