Re: postgresql-java (fwd)

sergiy grigoriev wrote:
> 
> ---------- Forwarded message ----------
> Date: Mon, 21 Aug 2000 18:33:39 +0300 (EEST)
> From: sergiy grigoriev <serg@localhost.localdomain>
> To: pgsql-questions@postgresql.org
> Subject: postgresql-java (fwd)
> 
>                 Hi !
>         While developing a Java GUI front-end to Postgresql I've faced the
> next problem:
> 
>         I want my program to
>   1. list all the available tables in the database
>   2. Show the structure of the chosen table.
> 
>  1.The first task is OK,it can easily be done by inspecting  the PG_TABLES
>  2. Please tell me how can I determine the structure of the table
>  (field names and types) using Postgres JDBC Driver in order to
> complete the second task.
> 
>         Thank you in advance for your reply.
> 
> 
You want to use the JDBC DatabaseMetaData class. In contains the the
methods getTables() and getColumns(). 
Refer to the JDBC API at
http://java.sun.com/products//jdk/1.2/docs/guide/jdbc/index.html
-- 
Dave Smith
Candata Systems Ltd.
(416) 493-9020
dave@candata.com