missing data for column

From: tel medola <tel(dot)medola(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: missing data for column
Date: 2016-07-01 20:20:16
Message-ID: CANRMYmh-UNytDX9a38QYZ9_RkHBp4AV4Pqbuc7+429wX8Hf83Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi.
I tried to import records using the "\copy" or "copy" binary file, but I'm
not getting.
The postgres is prompting me that the column is missing, but it is in
binary file (already opened it to check).
I tried the command "\copy", "copy". I also tried to pass the columns as a
parameter but did not succeed.

Example below:
COPY queue_log FROM '/Central001/queue_log3.bin';

ERROR: missing data for column "callid"
CONTEXT: COPY queue_log, line 1: "PGCOPY"

Could someone please help me?

PS:If there is any way to convert the binary file to text lat would
also, because
this way I could import in other ways.

Thank you.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2016-07-01 20:30:15 Re: missing data for column
Previous Message Joshua D. Drake 2016-06-24 17:19:37 Re: [SQL] Regarding RDS postgresql instance