Re: catalog info for sequences

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: catalog info for sequences
Date: 2008-02-11 19:53:47
Message-ID: 79130CA8-F7D1-45ED-B108-4A67DABA5E3B@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Feb 11, 2008, at 11:39 AM, Marc Munro wrote:

> Can someone please tell me how to extract the mix, max, increment
> by, etc, values for a sequence from the system catalogs. Is this in
> the manual somewhere (I couldn't find it)?

Take a look at information_schema.sequences for a list of sequence
names, and "select * from sequence_name" for information about a
specific sequence.

Cheers,
Steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2008-02-11 19:55:38 Re: Empty to NULL conversion - Ruby - Postgres ?
Previous Message Jeff Davis 2008-02-11 19:49:27 Re: Is PG a moving target?