From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Anil Amarakoon <awc(at)drytel(dot)net> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: pg_class et el -little OT |
Date: | 2003-02-03 00:58:17 |
Message-ID: | 1044233896.1280.91.camel@inspiron.cramers |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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(at)micro-automation(dot)net>
From | Date | Subject | |
---|---|---|---|
Next Message | Lars Stenberg | 2003-02-03 00:59:07 | Re: Coding style |
Previous Message | Bruce Momjian | 2003-02-03 00:55:15 | Re: Coding style |