resetting primary key after copy

From: Don Guernsey <dononyx(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: resetting primary key after copy
Date: 2007-02-12 17:28:40
Message-ID: 20070212172840.84125.qmail@web53508.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

does anyone know how to do this? I need to reset the primary key after I copy a
bunch of data to postgres. The other option would be to start my tables primary
key at a high number, like 3000000. Any Ideas?


____________________________________________________________________________________
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2007-02-12 17:45:57 Re: resetting primary key after copy
Previous Message Johannes Bruegmann 2007-02-12 16:51:16 Re: relation 12345 is still open