Re: missing data for column - Mailing list pgsql-sql

On 07/01/2016 01:20 PM, tel medola wrote:

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';

Have you looked at:

https://www.postgresql.org/docs/9.4/static/sql-copy.html

Binary Format

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

Could someone please help me?

If the example you show is complete I do see WITH FORMAT binary

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.

Where is the binary file coming from?

Thank you.

--
Adrian Klaver
adrian.klaver@aklaver.com