Re: SEQUENCES

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Rodrigo Sakai <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SEQUENCES
Date: 2006-10-03 14:59:58
Message-ID: 20061003145958.GA29003@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Oct 02, 2006 at 13:39:38 -0300,
Rodrigo Sakai <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br> wrote:
> Hi all,
>
>
>
> I need to get all sequences and their respective current values! Is there
> any catalog table or any other away to get this???

You can get their names from pg_class (with relkind = 'S') and then iterate
over the names and look at the table underlying each table (at last_value).

In response to

  • SEQUENCES at 2006-10-02 16:39:38 from Rodrigo Sakai

Browse pgsql-sql by date

  From Date Subject
Next Message William Leite Araújo 2006-10-03 15:19:19 Re: Update 3 columns w/ 1 function calc 3 values?
Previous Message paallen 2006-10-03 14:55:55 Update 3 columns w/ 1 function calc 3 values?