Postgres Pro
Downloads
Home   >   mailing lists

how to get info about tables in remote dB? - Mailing list pgsql-jdbc

From Mykola Dudar
Subject how to get info about tables in remote dB?
Date
Msg-id 000a01c2c664$2b81c7b0$a8f41881@MINIME
Whole thread Raw
List pgsql-jdbc
Tree view
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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: question about rollback and SQLException
Next
From: "Mykola Dudar"
Date:
Subject: Re: how to get info about tables in remote dB?