[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] missing data for column
From:       Steve Midgley <science () misuse ! org>
Date:       2016-07-01 22:20:13
Message-ID: CAJexoSLXf-LMugMSk-qVQqrfmPOnU46AadpLdvSXOOa4KG+GOg () mail ! gmail ! com
[Download RAW message or body]

You could experiment (in a sandbox environment!!) with removing columns
that are not being found in the backup file (like 'callid') and see if you
can get something to load?

Do you remember if there were any DDL statements in the backup? Could you
load this backup from into an empty database?

Steve


On Fri, Jul 1, 2016 at 1:20 PM, tel medola <tel.medola@gmail.com> 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';
>
> ERROR: missing data for column "callid"
> CONTEXT: COPY queue_log, line 1: "PGCOPY"
>
> Could someone please help me?
>
>
> 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.
>
> Thank you.
>

[Attachment #3 (text/html)]

<div dir="ltr">You could experiment (in a sandbox environment!!) with removing \
columns that are not being found in the backup file (like &#39;callid&#39;) and see \
if you can get something to load?<div><br></div><div>Do you remember if there were \
any DDL statements in the backup? Could you load this backup from into an empty \
database?</div><div><br></div><div>Steve</div><div><br></div></div><div \
class="gmail_extra"><br><div class="gmail_quote">On Fri, Jul 1, 2016 at 1:20 PM, tel \
medola <span dir="ltr">&lt;<a href="mailto:tel.medola@gmail.com" \
target="_blank">tel.medola@gmail.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div>Hi.<br>I tried to import records using \
the &quot;\copy&quot; or &quot;copy&quot; binary file, but I&#39;m not \
getting.<br>The postgres is prompting me that the column is missing, but it is in \
binary file (already opened it to check).<br>I tried the command &quot;\copy&quot;, \
&quot;copy&quot;. I also tried to pass the columns as a parameter but did not \
succeed.<br><br>Example below:<br>COPY queue_log FROM \
&#39;/Central001/queue_log3.bin&#39;;<br><br>ERROR: missing data for column \
&quot;callid&quot;<br>CONTEXT: COPY queue_log, line 1: \
&quot;PGCOPY&quot;<br><br>Could someone please help me?<br><br><br></div>PS:<span \
lang="en"><span>If</span> <span>there is any</span> <span>way to</span> <span>convert \
the binary</span> <span>file to</span> <span>text</span> <span>lat</span> <span>would \
also</span><span>,</span> <span>because this way</span> <span>I could</span> \
<span>import</span> <span>in other ways.</span></span><div><br>Thank \
you.<br></div></div> </blockquote></div><br></div>



[prev in list] [next in list] [prev in thread] [next in thread]