Thread: How to find the definition of a sequence ?

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

select * from seq_id_top;

Should give you what you want


> 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,


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

select * from seq_id_top

Travis

-----Original Message-----
From: Liviu BURCUSEL [mailto:liviu@voxline.ro]
Sent: Wednesday, June 11, 2003 9:47 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to find the definition of a sequence ?


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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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

SELECT * FROM seq_id_top

Liviu BURCUSEL schrieb:
> 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,