From: | snpe <snpe(at)snpe(dot)co(dot)yu> |
---|---|
To: | Andrew Bulmer <toastafari(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: describe table query? |
Date: | 2002-09-10 01:07:46 |
Message-ID: | 200209100307.46087.snpe@snpe.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-09-10 01:53:14 | Re: AutoCommit mode in PostgreSQL (7.3 beta1 from CVS 05.09.2002) |
Previous Message | Brett Schwarz | 2002-09-10 01:06:11 | Re: getting column names for tables.. |