Thread: Copy and serial type problem

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

You don't indicate how you're executing the copy.  If you're using a
script/program, just add your own counter as the first field in the copy.  I
do this 'all the time' from Perl scripts, and it works fine.  If you're
using psql, I haven't a clue unless you massage the input data before doing
the copy.

Rob

> -----Original Message-----
> From: Przemyslaw 'Morp][ik' Berlinski
> [mailto:morphik@irc.nospam.gdansk.pl]
> Sent: Sunday, July 22, 2001 1:13 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Copy and serial type problem
>
>
> 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
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>