Re: pg_put_line() Frustration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Use pg_copy_to and pg_copy_from instead...

Chris

Simon Hewitt wrote:
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



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux