From: | Daniel Serodio <daniel(at)checkforte(dot)com(dot)br> |
---|---|
To: | Mir Shafiqul Islam <mislam(at)mindspring(dot)com> |
Cc: | pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: showing table and columns |
Date: | 2002-09-26 20:34:17 |
Message-ID: | 1033072465.27015.1.camel@kelly |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2002-09-26 20:49:50 | Re: showing table and columns |
Previous Message | Mir Shafiqul Islam | 2002-09-26 20:16:08 | showing table and columns |