Received: from juniper.pharm.mun.ca (IDENT:jbowden@juniper.pharm.mun.ca [134.153.164.173]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA73082 for ; Mon, 12 Jul 1999 09:38:43 -0400 (EDT) (envelope-from jbowden@juniper.pharm.mun.ca) Received: from localhost (jbowden@localhost) by juniper.pharm.mun.ca (8.9.3/8.8.7) with ESMTP id LAA31278 for ; Mon, 12 Jul 1999 11:05:53 -0230 Date: Mon, 12 Jul 1999 11:05:53 -0230 (NDT) From: John Bowden To: pgsql-sql@postgresql.org Subject: SQL: Getting table structure Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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@www.pharm.mun.ca