Re: showing table and columns - Mailing list pgsql-jdbc

From Daniel Serodio
Subject Re: showing table and columns
Date
Msg-id 1033072465.27015.1.camel@kelly
Whole thread Raw
In response to showing table and columns  (Mir Shafiqul Islam <mislam@mindspring.com>)
List pgsql-jdbc
Sure, that's answered in the PostgreSQL FAQ:

<quote>

4.3) How do I get a list of tables or other things I can see in psql?

You can read the source code for psql in file
pgsql/src/bin/psql/describe.c. It contains SQL commands that generate
the output for psql's backslash commands. You can also start psql with
the -E option so it will print out the queries it uses to execute the
commands you give.

</quote>

On Thu, 2002-09-26 at 17:16, Mir Shafiqul Islam wrote:
> Is there a way to construct a SQL statement to retrieve all the tables
> and also columns information ?
>
> I know, using \d from psql shows the table and \d tablename will show
> the columns but that does not work from within jdbc.
>
> Thanks
> Mir

--
[]'s
Daniel Serodio


pgsql-jdbc by date:

Previous
From: Mir Shafiqul Islam
Date:
Subject: showing table and columns
Next
From: Dave Cramer
Date:
Subject: Re: showing table and columns