Re: How to obtain a sequence's increment value from the system catalog

[Ragnar <gnari@xxxxxxx>]

have you tried:
select * from my_seq;

or are you looking for the functions currval() or lastval()
http://www.postgresql.org/docs/8.2/interactive/functions-sequence.html

gnari


On mán, 2007-07-09 at 09:43 +0200, Wouter Gazendam wrote:
> Hi,
> 
> I'd like to query a sequence's increment value from the system
> catalog. I tried looking at
> http://www.postgresql.org/docs/8.1/static/catalog-pg-class.html but
> I'm stuck here.
> 
> Any ideas/help would be appreciated.
> 
> Thanks,
> 
> Wouter Gazendam