SQL: Getting table structure

From: John Bowden <jbowden(at)juniper(dot)pharm(dot)mun(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL: Getting table structure
Date: 1999-07-12 13:35:53
Message-ID: Pine.LNX.4.10.9907121103450.31268-100000@juniper.pharm.mun.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi -

I'm having some trouble using my pgsql database. I've got it set
up with php (though the problem isn't there). How can I get (from say a
SELECT query) the structure for a given table?

I've used the pg_* tables to get other information before; can I
do the same here? It's not feasible to run psql over the web.

John
jbowden(at)www(dot)pharm(dot)mun(dot)ca

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Good 1999-07-12 13:50:15 calculating percentages
Previous Message Nikolay Mijaylov 1999-07-12 08:21:02 Stupid question about default time value