Re: catalog info for sequences - Mailing list pgsql-general

From Steve Atkins
Subject Re: catalog info for sequences
Date
Msg-id 79130CA8-F7D1-45ED-B108-4A67DABA5E3B@blighty.com
Whole thread Raw
In response to catalog info for sequences  (Marc Munro <marc@bloodnok.com>)
List 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


pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Is PG a moving target?
Next
From: Jeff Davis
Date:
Subject: Re: Empty to NULL conversion - Ruby - Postgres ?