This isn't quite what I'm looking for, though.... I can't run a script on that machine, so I need to retrieve it with an SQL query. Ie. "SELECT * from data_key_table_name_something"... *smile* Judging from the few responses so far, it doesn't sound like there's an easy way to do this. On Sun, 19 Mar 2000, omid omoomi wrote: > 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 > >
