Copy and serial type problem - Mailing list pgsql-general

From Przemyslaw 'Morp][ik' Berlinski
Subject Copy and serial type problem
Date
Msg-id 9jf8om$4gt$1@news.tpi.pl
Whole thread Raw
List pgsql-general
Hi,

I've created a small table:

CREATE TABLE "table" (
  "id" int4 DEFAULT nextval('"table_idd_seq"') NOT NULL,
  "file" character varying(40) NOT NULL
);

Table sequence 'table_idd_seq' is also available with a next id number.

Question is how to use postgres copy function with this 'id'. Table 'table'
is not empty... I've tried to insert nextval("table_idd_seq") into file but
it doesn't work.

Any help would be appreciated.

TIA
Morp][ik




pgsql-general by date:

Previous
From: Nils Zonneveld
Date:
Subject: Re: Questions about rollback and commit
Next
From: ajmayo@my-deja.com (Andrew Mayo)
Date:
Subject: Re: Postgresql revisited. Some questions about the product