Re: missing data for column

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(dot)klaver(at)aklaver(dot)com