Re: Table definition

Probably there is no direct way get the definition (i could not find one atleast).
You can probably write a custom function which gives all columns, indexes and formulate a create table statement (text definition).

Let us know if you find a way out.

- Goutam

________________________________

From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Bruno Prévost
Sent: Tuesday, November 16, 2004 9:04 AM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Table definition



Hi,
Anybody know how to obtain the table definition in text.
Something like "select definition from pg_catalog.pg_views where viewname = 'xxx'" but for a table.
Thanks
Bruno

Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.