You can just use DatabaseMetaData getTables and specify SEQUENCE to get
the sequence tables.
Dave
On Sun, 2003-02-02 at 19:39, Anil Amarakoon wrote:
> Hi All;
>
> I just want query database and get the structures in in my application.
>
> If I run select * from pg_class where tableowner='myname';
> get all the tables tables created by me.
>
> Is there any other place that I can get file names and sequnces??
>
> like this
> select * from pg_table where tableName=role;
>
> will give you
>
> Id int
> roleName text etc..
>
> same kind of info for the sequence..
>
> Thank you in advance for any replies.
>
> awc
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Dave Cramer <Dave@micro-automation.net>
