Re: missing data for column

Thanks Adrian.

My postgres is crash and I can no longer read the tables. I can no longer climb
the base or anything. I just remember that these tables were exported before
the crash and with headache, I forgot to pass the correct parameters.

Thanks and sorry.

2016-07-01 17:30 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

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