Skip site navigation (1) Skip section navigation (2)

how to get info about tables in remote dB?

From: "Mykola Dudar" <dmykola(at)hpcerc(dot)unm(dot)edu>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: how to get info about tables in remote dB?
Date: 2003-01-28 00:28:24
Message-ID: 000a01c2c664$2b81c7b0$a8f41881@MINIME (view raw or flat)
Thread:
Lists: pgsql-jdbc
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

Responses

pgsql-jdbc by date

Next:From: Mykola DudarDate: 2003-01-28 00:38:49
Subject: Re: how to get info about tables in remote dB?
Previous:From: Kris JurkaDate: 2003-01-27 18:29:02
Subject: Re: question about rollback and SQLException

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group