How to find the definition of a sequence ?

Started by Liviu BURCUSELalmost 23 years ago3 messagesgeneral

liviu@voxline.ro

almost 23 years ago

Hi !
I have a database created by a friend of mine. In it there is a sequence
called seq_id_top. How can I find out its definition (start, increment,
max value) ?

I use version 7.3.2

Many thanks in advance,
--
Liviu BURCUSEL
Registered Linux User #221627
5:44pm up 8:13, 6 users, load average: 0.08, 0.09, 0.13

Thomas Kellerer

spam_eater@gmx.net

almost 23 years ago

In reply to: Liviu BURCUSEL (#1)

Re: How to find the definition of a sequence ?

SELECT * FROM seq_id_top

Liviu BURCUSEL schrieb:

Show quoted text

Hi !
I have a database created by a friend of mine. In it there is a sequence
called seq_id_top. How can I find out its definition (start, increment,
max value) ?

I use version 7.3.2

Many thanks in advance,

tgl@sss.pgh.pa.us

almost 23 years ago

In reply to: Liviu BURCUSEL (#1)

Re: How to find the definition of a sequence ?

Liviu BURCUSEL <liviu@voxline.ro> writes:

I have a database created by a friend of mine. In it there is a sequence
called seq_id_top. How can I find out its definition (start, increment,
max value) ?

SELECT * FROM seq_id_top;

regards, tom lane