[SQL] Sequences

Hi! Where are stored the sequence information? How I can query the properties of a sequence like increment, max/min value, cache? I'm looking for a table like user_sequences in Oracle, where I can query all of my sequences. Thanks Andre -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.o

Re: [SQL] Sequences

Thanks, I have used SELECT sequence_name FROM information_schema.sequences WHERE sequence_catalog=? AND sequence_schema=? and then I can use select * from It seems to work :-) Andre Chris Browne wrote: Andre Rothe writes: Where are stored the sequence information? How I can query the