From: Goutam Paruchuri <gparuchuri@oneil.com>
To: Bruno Prévost <bp@interaction.ws>
To: pgsql-sql@postgresql.org
Subject: Re: Table definition
Date: Tue, 16 Nov 2004 10:07:21 -0500
Message-ID: <B2C547DF42419645804F05B54290755ADC7CE0@DAYTONEX.oneilinc.net> (raw)
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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Bruno Prévost
Sent: Tuesday, November 16, 2004 9:04 AM
To: pgsql-sql@postgresql.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gparuchuri@oneil.com, bp@interaction.ws
Subject: Re: Table definition
In-Reply-To: <B2C547DF42419645804F05B54290755ADC7CE0@DAYTONEX.oneilinc.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox