pg_class et el -little OT

From: Anil Amarakoon <awc(at)drytel(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: pg_class et el -little OT
Date: 2003-02-03 00:39:00
Message-ID: 3E3DBA23.20F4FFDB@drytel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Lars Stenberg 2003-02-03 00:55:14 Re: pg_class et el -little OT
Previous Message Nic Ferrier 2003-02-02 21:23:35 Re: Coding style