Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get sequence info? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: How to get sequence info?
Date
Msg-id Pine.BSO.4.64.0705041315001.9306@leary.csoft.net
Whole thread Raw
In response to How to get sequence info?  ("Gary Greenberg" <gary@icontrol.com>)
List pgsql-jdbc
Tree view 

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

pgsql-jdbc by date:

Previous
From: "Gary Greenberg"
Date:
Subject: How to get sequence info?
Next
From: Dave Cramer
Date:
Subject: jdbc4 implementation errors building