Thread: showing table and columns

showing table and columns

From
Mir Shafiqul Islam
Date:
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


Re: showing table and columns

From
Daniel Serodio
Date:
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


Re: showing table and columns

From
Dave Cramer
Date:
I'm inclined to tell you to read the jdbc api specs, and you should, but
the answer is DatabaseMetaData.getTables, etc.

Dave
On Thu, 2002-09-26 at 16: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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>