Thread

RE: Copy and serial type problem

Creager, Robert S <creagrs@louisville.stortek.com> — 2001-07-23T19:13:06Z

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)
>