Re: Statistics from Sequences

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