Re: How to find the definition of a sequence ?

From: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
To: Liviu BURCUSEL <liviu(at)voxline(dot)ro>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to find the definition of a sequence ?
Date: 2003-06-11 14:44:17
Message-ID: BB0CFED1.1D5FA%a.witney@sghms.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Williams, Travis L, NPONS 2003-06-11 14:45:05 insert question..
Previous Message Stephan Szabo 2003-06-11 14:35:26 Re: Return Record with CASE problem