| From: | "Mykola Dudar" <dmykola(at)hpcerc(dot)unm(dot)edu> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: how to get info about tables in remote dB? |
| Date: | 2003-01-28 00:38:49 |
| Message-ID: | 001401c2c665$a02cead0$a8f41881@MINIME |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Sorry, found the answer in FAQ.
No answer need!
Sorry, one more time..
----- Original Message -----
From: Mykola Dudar
To: pgsql-jdbc(at)postgresql(dot)org
Sent: Monday, January 27, 2003 5:28 PM
Subject: [JDBC] how to get info about tables in remote dB?
Hi,
I am using PostgreSQL JDBC driver to connect to PostgreSQL server. And I need to get a list of tables under the current user and get information about tables - # of tables, # of columns in them, type of columns, etc.
For intanse, in oracle I could this by running:
select * from user_tables; -- give the list of tables
descr table_name; - gives information about the table
Ideas?
Thanks,
Mykola
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pier Paolo Bortone | 2003-01-28 10:59:28 | BYTEA dump compatibility |
| Previous Message | Mykola Dudar | 2003-01-28 00:28:24 | how to get info about tables in remote dB? |