autoupdate sequences after copy

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: autoupdate sequences after copy
Date: 2003-10-09 07:10:02
Message-ID: 20031009071002.74857.qmail@web40605.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to have p/k sequences get automatically
set to max(id)+1 after COPY's like the following?

copy table1 (id,name) from stdin;
1 abc
2 def
3 fhi
\.

CSN

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2003-10-09 07:16:05 int1?
Previous Message Shridhar Daithankar 2003-10-09 06:42:24 Re: Humor me: Postgresql vs. MySql (esp. licensing)