Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-php by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group