Hi, There are some system tables in any pg database which contain information about table/field names/types and descriptions. use -e with psql command, and look at the sql code when running /d commands. regards. Omid Omoomi >From: Stan Jacobs <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [GENERAL] How to retrieve table definition in SQL >Date: Sun, 19 Mar 2000 03:40:43 -0800 (PST) > > >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 - > > > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
