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

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

From

"Wouter Gazendam"

Date:

09 July 2007, 07:43:15

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

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

From

Ragnar

Date:

09 July 2007, 09:03:25

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

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

From

"Wouter Gazendam"

Date:

09 July 2007, 11:39:49

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@hive.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/