Postgres - how to skip 'sequence' columns

[email protected] ("Gary .")
Newsgroups php.db
Message-ID <[email protected]>
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).

The csv file contains only data for the second and subsequent
columns, so anyway needs to "hop right" one column.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.