describe table query? - Mailing list pgsql-general

From Andrew Bulmer
Subject describe table query?
Date
Msg-id 20020909213002.62619.qmail@web20607.mail.yahoo.com
Whole thread Raw
Responses Re: describe table query?  (Darren Ferguson <darren@crystalballinc.com>)
Re: describe table query?  (snpe <snpe@snpe.co.yu>)
Re: describe table query?  (Alex Krohn <alex@gossamer-threads.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: snpe
Date:
Subject: Re: AutoCommit mode in PostgreSQL (7.3 beta1 from CVS 05.09.2002)
Next
From: Darren Ferguson
Date:
Subject: Re: describe table query?