> What I would like to do, use PostgreSQL and PHP, is list all the columns for
> a given table. (Having finally choked the list of tables from postgre). In
> MySQL it is something like this "SHOW COLUMNS FROM {tablename} FROM
> {databasename}". I'm assuming I'm missing something obvious and bonehead,
> but I can't seem to translate that into postgreSQL to save my bacon.
See the example on this page:
http://us2.php.net/manual/en/function.pg-meta-data.php
-philip