Feedback-ID: i374947ac:Fastmail
Message-ID: <85b3aab6-91ef-496e-88d5-047f170e1a06@quadratum-braccas.com>
Date: Tue, 9 Jul 2024 16:36:33 -0600
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Language: en-US
From: Sbob <sbob@quadratum-braccas.com>
Subject: OT: help with pgloader
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/85b3aab6-91ef-496e-88d5-047f170e1a06%40quadratum-braccas.com>
Precedence: bulk

All;


I created a few tables with pgbench, then I did this:

1)  copied the data from pgbench_accounts to a data file with a pipe '|' 
delimiter:

  copy pgbench_accounts to '/var/lib/pgsql/copy/pgbench_accounts.dat' 
delimiter ' ;


2) installed pgloader

# dnf -y install pgloader


3) deleted all data from the pgbench_accounts table:

DELETE FROM pgbench_accounts ;


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)

Can someone point me in the right direction ?


Thanks in advance


pgloader run:


$ 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)

In context COMMAND:

While parsing COMMAND. Expected:

      the character Tab
   or the character Newline
   or the character Return
   or the character Space
   or the character , (COMMA)
   or the string "--"
   or the string "/*"
   or the character ; (SEMICOLON)
   or the string "after"
   or the string "before"
   or the string "set"
   or the string "with"
An unhandled error condition has been signalled: At

   TARGET TABLE public.pgbench_accounts
    WITH delimiter '|'

                      ^ (Line 5, Column 19, Position 141)

In context COMMAND:

While parsing COMMAND. Expected:

      the character Tab
   or the character Newline
   or the character Return
   or the character Space
   or the character , (COMMA)
   or the string "--"
   or the string "/*"
   or the character ; (SEMICOLON)
   or the string "after"
   or the string "before"
   or the string "set"
   or the string "with"


What I am doing here?

At

   TARGET TABLE public.pgbench_accounts
    WITH delimiter '|'

                      ^ (Line 5, Column 19, Position 141)

In context COMMAND:

While parsing COMMAND. Expected:

      the character Tab
   or the character Newline
   or the character Return
   or the character Space
   or the character , (COMMA)
   or the string "--"
   or the string "/*"
   or the character ; (SEMICOLON)
   or the string "after"
   or the string "before"
   or the string "set"
   or the string "with"