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

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 <gnari(at)hive(dot)is> wrote:
>
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>