Re: how to use nextval() - Mailing list pgsql-sql

From Stephane Schildknecht
Subject Re: how to use nextval()
Date
Msg-id 1025872101.10925.289.camel@fukse
Whole thread Raw
In response to how to use nextval()  (juerg.rietmann@pup.ch)
List pgsql-sql
Le ven 05/07/2002 à 14:03, juerg.rietmann@pup.ch a écrit :
> Hello there
>
> I have an idea how to solve my problem on copy a record to a new one in the
> same table. To do so I need the next value for the primary key.
>
> Using :
>
> select nextval('pk_auftrag') as nextkey from auftrag;
>
> I get an error like : Relation pk_auftrag does not exist !
>
> Thanks for any help ... jr
Try to get the right name of the sequence.
By default, something like auftrag_auftrag_id_seq, if auftrag_id is the
serial primary key.

select nextval('auftrag_auftrag_id_seq') as nextkey;

S@S





pgsql-sql by date:

Previous
From: Chantal Ackermann
Date:
Subject: Re: Selecting data from a table created in another database...
Next
From: Achilleus Mantzios
Date:
Subject: Re: how to use nextval()