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 -