how does setval() work??? - Mailing list pgsql-novice

From chris Günther
Subject how does setval() work???
Date
Msg-id 20010110170656.130bffac.guenther@uscreen.de
Whole thread Raw
Responses Re: how does setval() work???
List pgsql-novice
Hi there,

I have a couple of tables in my database, which are part-filled from the
beginning on. In subsequent live there are more datasets to come into
theses tables, but the first ones need to have specific keys in the
primary key column. I use a serial on this column and after creating the
database with the default values in the table I need to set my sequence
by hand using setval() I think. But I just can't figure out how this works.

Can anyone give me an example???

    chris

--

pgsql-novice by date:

Previous
From: Alfonso Peniche
Date:
Subject: Re: converting .xls to delimited file
Next
From: "Oliver Elphick"
Date:
Subject: Re: how does setval() work???