Re: Table definition
| От | Goutam Paruchuri |
|---|---|
| Тема | Re: Table definition |
| Дата | |
| Msg-id | B2C547DF42419645804F05B54290755ADC7CE0@DAYTONEX.oneilinc.net обсуждение исходный текст |
| Ответ на | Table definition (Bruno Prévost <bp@interaction.ws>) |
| Список | pgsql-sql |
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 definitionHi,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.ThanksBruno
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.
В списке pgsql-sql по дате отправления: