agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Adrian Klaver <adrian.klaver@aklaver.com>
To: tel medola <tel.medola@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: missing data for column
Date: Fri, 1 Jul 2016 13:30:15 -0700
Message-ID: <b087650e-c44e-e5fc-4e7a-b7897d4c2675@aklaver.com> (raw)
In-Reply-To: <CANRMYmh-UNytDX9a38QYZ9_RkHBp4AV4Pqbuc7+429wX8Hf83Q@mail.gmail.com>
References: <CANRMYmh-UNytDX9a38QYZ9_RkHBp4AV4Pqbuc7+429wX8Hf83Q@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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


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

view thread (7+ messages)  latest in thread

Message-ID: <b087650e-c44e-e5fc-4e7a-b7897d4c2675@aklaver.com>
Permalink:  ../b087650e-c44e-e5fc-4e7a-b7897d4c2675@aklaver.com/
Also on:    postgresql.org/message-id/b087650e-c44e-e5fc-4e7a-b7897d4c2675@aklaver.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: adrian.klaver@aklaver.com, tel.medola@gmail.com
  Subject: Re: missing data for column
  In-Reply-To: <b087650e-c44e-e5fc-4e7a-b7897d4c2675@aklaver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox