Re: [SQL] Statistics from Sequences

[Michael Fuhr]

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend