describe table query?

From: Andrew Bulmer <toastafari(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: describe table query?
Date: 2002-09-09 21:30:02
Message-ID: 20020909213002.62619.qmail@web20607.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2002-09-09 22:15:57 Re: describe table query?
Previous Message snpe 2002-09-09 21:16:39 Re: this is postgresql question..how do i drop unique constraint on a column?