Re: [SQL] Sequences

2009-07-06 Thread Andre Rothe
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

[SQL] Sequences

2009-07-06 Thread Andre Rothe
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