Ah, 'select * from my_seq;' did the trick.
I mistakenly assumed that all information entered in DDL statements would
end up in the system catalog.
Thank you for the quick response,
Wouter Gazendam
On 7/9/07, Ragnar <[EMAIL PROTECTED]> wrote:
have you tried:
select * from my_seq;
or are you
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 fro
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
