Skip site navigation (1) Skip section navigation (2)

Re: sequence properties

From: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
To: booli2 <booli2(at)go2(dot)pl>
Cc: Postgresql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: sequence properties
Date: 2001-08-19 09:22:01
Message-ID: 3B7F8539.5D36080C@catalyst.net.nz (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-novice by date

Next:From: Horst HerbDate: 2001-08-19 13:20:06
Subject: Re: how to use record type
Previous:From: booli2Date: 2001-08-19 07:48:50
Subject: sequence properties

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group