Re: Statistics from Sequences

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.