Subject: Re: missing data for column
To: tel medola <tel.medola@gmail.com>, pgsql-sql@postgresql.org
References: 
 <CANRMYmh-UNytDX9a38QYZ9_RkHBp4AV4Pqbuc7+429wX8Hf83Q@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <b087650e-c44e-e5fc-4e7a-b7897d4c2675@aklaver.com>
Date: Fri, 1 Jul 2016 13:30:15 -0700
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:45.0) Gecko/20100101
 Thunderbird/45.1.1
MIME-Version: 1.0
In-Reply-To: 
 <CANRMYmh-UNytDX9a38QYZ9_RkHBp4AV4Pqbuc7+429wX8Hf83Q@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql