Question about SERIAL
Hi,
is there a possibilty to increment a sequence when data are imported form a
textfile using the \copy command.
Thanks Erwin
After the \copy, set the new sequence with setval (but you knew this; your
last message to the group was asking about how to use setval: what's your
real question here?)
- J.
Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant
Show quoted text
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Erwin Ambrosch
Sent: Tuesday, May 14, 2002 10:24 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Question about SERIALHi,
is there a possibilty to increment a sequence when data are
imported form a
textfile using the \copy command.Thanks Erwin
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Look at the SETVAL function in the documentation about sequences...
On Tue, 14 May 2002, Erwin Ambrosch wrote:
Show quoted text
Hi,
is there a possibilty to increment a sequence when data are imported form a
textfile using the \copy command.Thanks Erwin
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)