| From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
|---|---|
| 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:49:50 |
| Message-ID: | 1033073390.1957.106.camel@inspiron.cramers |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2002-09-26 20:56:26 | Re: Prepared statement performance... |
| Previous Message | Daniel Serodio | 2002-09-26 20:34:17 | Re: showing table and columns |