by chestercyoung@[EMAIL PROTECTED]
(chester c young)
May 2, 2008 at 03:33 PM
--- Alexy Khrabrov <deliverable@[EMAIL PROTECTED]
> wrote:
> Now I want to number the rows, adding an id column
> as an autoincrement from a sequence. How should I do the im****t now
> for the sequence to work -- should I add the id column last, so it
> will not be filled by copy and presumably autoincrement?
use a sequence
restart sequence to 1 before copy
have column id default to nextval('seq')
when doing copy don't have a column matching your id (duh)
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
