Re: Statistics from Sequences - Mailing list pgsql-sql

On Tue, Sep 06, 2005 at 11:43:44PM -0300, Joÿffffffffffe3o Carvalho 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

See the output from the following example:

CREATE SEQUENCE fooseq;

SELECT u.usename
FROM pg_class AS c JOIN pg_user AS u ON u.usesysid = c.relowner
WHERE c.relname = 'fooseq';

SELECT * FROM fooseq;

-- 
Michael Fuhr