Re: Question about SERIAL

From: "Joel Burton" <joel(at)joelburton(dot)com>
To: <ambre(at)ebutec(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question about SERIAL
Date: 2002-05-14 16:17:24
Message-ID: JGEPJNMCKODMDHGOBKDNGEDKCOAA.joel@joelburton.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Erwin Ambrosch
> Sent: Tuesday, May 14, 2002 10:24 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Wright 2002-05-14 16:22:11 foreign keys not working
Previous Message Joel Burton 2002-05-14 16:16:05 Re: Question about setval() function