pg_put_line() Frustration
От | Simon Hewitt |
---|---|
Тема | pg_put_line() Frustration |
Дата | |
Msg-id | BAY103-F2DAC914A1FB677D5AFCC1D5E90@phx.gbl обсуждение исходный текст |
Ответы |
Re: pg_put_line() Frustration
Re: pg_put_line() Frustration |
Список | 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 по дате отправления: