Re: sequence properties - Mailing list pgsql-novice

From Andrew McMillan
Subject Re: sequence properties
Date
Msg-id 3B7F8539.5D36080C@catalyst.net.nz
Whole thread Raw
In response to sequence properties  ("booli2" <booli2@go2.pl>)
List pgsql-novice
booli2 wrote:
>
> I've got a question: how to get sequence properties (minvalue, maxvalue,
> increment, cache, etc.) using SQL queries ?

SELECT * FROM my_sequence_seq;

Cheers,
                    Andrew.
--
_____________________________________________________________________
        Andrew McMillan, e-mail: Andrew @ catalyst . net . nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64(27)246-7091, Fax:+64(4)499-5596, Office: +64(4)499-2267xtn709

pgsql-novice by date:

Previous
From: "booli2"
Date:
Subject: sequence properties
Next
From: travep
Date:
Subject: Re: Queries seem to lock up shell session