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

Sorry, found the answer in FAQ.

No answer need!

Sorry, one more time..

 

----- Original Message -----

From: Mykola Dudar

To: pgsql-jdbc@xxxxxxxxxxxxxx

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