Kevin,
> How do I retrieve a list of columns for a table from an outside
> application? I don't want to retrieve any rows from the table just the
> column related data like what is retrieved using '\d [table name]' in
> psql. Can this be done using a simple Select statement?
Yes. Look up INFORMATION_SCHEMA in the PostgreSQL Docs.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco