Copy and serial type problem

From: "Przemyslaw 'Morp][ik' Berlinski" <morphik(at)irc(dot)nospam(dot)gdansk(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Copy and serial type problem
Date: 2001-07-22 19:13:26
Message-ID: 9jf8om$4gt$1@news.tpi.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-07-22 19:29:02 Re: Planner estimates cost of 'like' a lot lower than '='??
Previous Message Mats Lofkvist 2001-07-22 18:36:43 Re: Planner estimates cost of 'like' a lot lower than '='??