Re: describe table query? - Mailing list pgsql-general

From snpe
Subject Re: describe table query?
Date
Msg-id 200209100307.46087.snpe@snpe.co.yu
Whole thread Raw
In response to describe table query?  (Andrew Bulmer <toastafari@yahoo.com>)
Responses Re: describe table query?
List pgsql-general
If You use java then that is DatabaseMetaData.getColumns etc

regards
Haris Peco
On Monday 09 September 2002 11:30 pm, Andrew Bulmer wrote:
> I'm trying to write an Access clone in java that will
> use PostGres as a backend. Problem is, I need to be
> able to list all the fields (and data types) in a
> table. I know about "\d" but that only seems to work
> on the command line client (doesn't work if I pass it
> in as a query). I know in mysql DESCRIBE <table> will
> do it... is there an equivalent in postgres? I tried
> google but all I could find were references to the \d command.
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


pgsql-general by date:

Previous
From: snpe
Date:
Subject: Column type, size, precision in PostgreSQL
Next
From: Dan Ostrowski
Date:
Subject: Re: describe table query?