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 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/
