Re: [SQL] Table definition

[Goutam Paruchuri]

Title: Les consultants Interaction | stationery

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Prévost Sent: Tuesday, November 16, 2004 9:04 AM To: [EMAIL PROTECTED] 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.