pg_put_line() Frustration

From: "Simon Hewitt" <sejh79(at)hotmail(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: pg_put_line() Frustration
Date: 2005-06-20 13:29:47
Message-ID: BAY103-F2DAC914A1FB677D5AFCC1D5E90@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

Hi all,

I am currently working on an application that will input multple lines into
a Postgre database. I am using the following code

$sql = "COPY table_2 FROM STDIN DELIMITER AS '\t'";
pg_query($dbc, $sql);
$sql = $data1."\t".$data2."\t".implode("\t",
$data)."\ttrue\t05-05-2005\n";
pg_put_line($this->dbc, $sql);
if(!pg_put_line($dbc, "\\N"))
{
pg_end_copy($dbc);
$error_message('Could not enter details');
}
else
{
pg_end_copy($this->dbc);
unset($data);
}

This gives me an example line like

57 BELF 254 0 10877 5138 0 0 true 05-05-2005

To go into a table with fields INT, CHAR(4) INT, INT, INT, INT, INT, INT,
BOOL, DATE

However, its not going in...

I'm getting an error

ERROR: missing data for column "col2"

With no data being inserted.

If anyone could point out where I'm going wrong I'd be forever in their debt

Thanks

Simon

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Michael Fuhr 2005-06-20 14:05:31 Re: pg_put_line() Frustration
Previous Message Felipe Fernandez 2005-06-18 17:07:44 Problemas con 7.4.7 y php 4-10 debian3.1