On Feb 11, 2008, at 11:39 AM, Marc Munro wrote:
Can someone please tell me how to extract the mix, max, increment
by, etc, values for a sequence from the system catalogs. Is this in
the manual somewhere (I couldn't find it)?
Take a look at information_schema.sequences for a list of sequence
names, and "select * from sequence_name" for information about a
specific sequence.
Cheers,
Steve
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
