Thread: how to get info about tables in remote dB?

how to get info about tables in remote dB?

From
"Mykola Dudar"
Date:
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

Re: how to get info about tables in remote dB?

From
"Mykola Dudar"
Date:
Sorry, found the answer in FAQ.
No answer need!
Sorry, one more time..
 
----- Original Message -----
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