how does setval() work???

From: chris Gnther <guenther(at)uscreen(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: how does setval() work???
Date: 2001-01-10 16:06:56
Message-ID: 20010110170656.130bffac.guenther@uscreen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

--

Browse pgsql-novice by date

  From Date Subject
Next Message William Staniewicz 2001-01-10 16:23:08 converting .xls to delimited file
Previous Message Jeff Eckermann 2001-01-10 15:47:42 RE: converting .xls to delimited file