pg_put_line() Frustration

Поиск
Список
Период
Сортировка
От Simon Hewitt
Тема pg_put_line() Frustration
Дата
Msg-id BAY103-F2DAC914A1FB677D5AFCC1D5E90@phx.gbl
обсуждение исходный текст
Ответы Re: pg_put_line() Frustration  (Michael Fuhr <mike@fuhr.org>)
Re: pg_put_line() Frustration  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список 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



В списке pgsql-php по дате отправления:

Предыдущее
От: Felipe Fernandez
Дата:
Сообщение: Problemas con 7.4.7 y php 4-10 debian3.1
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: pg_put_line() Frustration