[GENERAL] How to retrieve table definition in SQL

[Stan Jacobs]

Hi everyone,

This probably isn't a Postgres-specific question, but I'm hoping that
someone knows the answer to this off the top of their heads... :-)

I'd like to retrieve the table definition via SQL.  I'm using ColdFusion
to access a PostgreSQL 6.5.3 database, and I'd like to retrieve the table
info, field names/types/sizes, so that my Coldfusion page/script can
dynamically build the html forms to edit the tables.

Any ideas how to get to this in SQL?  I have another C++ class which
builds nice table headers with this info, but ColdFusion doesn't seem to
do that with the returned data.


        Thanks!

        - Stan -