Re: How to get sequence info?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Gary Greenberg <gary(at)icontrol(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: How to get sequence info?
Date: 2007-05-04 17:18:23
Message-ID: Pine.BSO.4.64.0705041315001.9306@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Fri, 4 May 2007, Gary Greenberg wrote:

> I need to find out what sequences were created in the database.
>
> Does anyone know how to do it?

Sequences are returned as tables with a TABLE_TYPE of SEQUENCE, so you can
say:

DatabaseMetaData.getTables("%","%","%", new String[]{"SEQUENCE"});

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2007-05-05 16:37:03 jdbc4 implementation errors building
Previous Message Gary Greenberg 2007-05-04 17:05:34 How to get sequence info?