describe table query?
Andrew Bulmer <toastafari@yahoo.com>
From: Andrew Bulmer <toastafari@yahoo.com>
To: pgsql-general@postgresql.org
Date: 2002-09-09T21:30:02Z
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