Re: describe table query?

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)

In response to

Responses

Browse pgsql-general by date

  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..