Re: [PHP-DB] Postgres - how to skip 'sequence' columns

Gary . wrote:
> Is it possible to skip column(s) in the target table when using
> pg_copy_from? When I tried to bulk insert some data from a csv
> file by way of pg_copy_from I received the error "Warning:
> pg_copy_from() [function.pg-copy-from]: Copy command failed:
> ERROR: permission denied for relation xyz", pretty much as I
> expected since things look like:
> 
> CREATE SEQUENCE xyz;
> CREATE TABLE some_table (
>   id int NOT NULL PRIMARY KEY DEFAULT nextval('xyz')
> ...
> (i.e. the first column is automatically populated by the db itself).

It seems not from looking at the php manual.

You could use http://www.php.net/manual/en/function.pg-put-line.php instead.

-- 
Postgresql & php tutorials
http://www.designmagick.com/