List sequence assigned to primary key - Mailing list pgsql-novice

From Brian Johnson
Subject List sequence assigned to primary key
Date
Msg-id 20021105.WhT.79991700@192.168.0.1
Whole thread Raw
List pgsql-novice
I added a few records to a table and assigned numbers to the id field - now when I
try to add records properly, it says that it can't accept duplicate values on the
primary field (id)

Although there were only a few records and I could just redo them, I wonder if
there is another method (for future reference)

So here are my two questions

1. How can you list (find out) the sequence name assigned to a primary key?

2. How can you change that sequence value?


I searched a bunch of web sites but had trouble narrowing my search to less than
about 30,000 hits


pgsql-novice by date:

Previous
From: Kassel Ben CRBE
Date:
Subject: Re: AutoIncrement not working on this table only
Next
From: "Henshall, Stuart - Design & Print"
Date:
Subject: Re: List sequence assigned to primary key