pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Bruno Wolff III <bruno@wolff.to>
To: Joÿffffffffffe3o Carvalho <joaocarvalho127@yahoo.com.br>
Cc: PG-SQL lista de mail <pgsql-sql@postgresql.org>
Subject: Re: Statistics from Sequences
Date: Tue, 6 Sep 2005 22:38:33 -0500
Message-ID: <20050907033833.GB31843@wolff.to> (raw)
In-Reply-To: <20050907024344.19853.qmail@web50606.mail.yahoo.com>
References: <20050907024344.19853.qmail@web50606.mail.yahoo.com>

On Tue, Sep 06, 2005 at 23:43:44 -0300,
  Joÿffffffffffe3o Carvalho <joaocarvalho127@yahoo.com.br> wrote:
> Is it possible to get from a sequence:
> 
>    The sequence owner
>    The min value
>    The max value
>    The increment value
>    The last used number

Yes. Associated with each sequence is a one row table with the name of the
sequence. Note that numbers can be allocated and not used, so the last_value
may not be exactly what you want.

To get the owner you can combine pg_class with pg_user to get the table
owner. I didn't see this information in the information schema.

view thread (6+ messages)  latest in thread

Message-ID: <20050907033833.GB31843@wolff.to>
Permalink:  ../20050907033833.GB31843@wolff.to/
Also on:    postgresql.org/message-id/20050907033833.GB31843@wolff.to

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: bruno@wolff.to, joaocarvalho127@yahoo.com.br
  Subject: Re: Statistics from Sequences
  In-Reply-To: <20050907033833.GB31843@wolff.to>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox