X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 38C343A4039 for ; Tue, 16 Nov 2004 15:11:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61168-08 for ; Tue, 16 Nov 2004 15:11:06 +0000 (GMT) Received: from meridius.oneil.com (meridius.oneil.com [66.194.184.36]) by svr1.postgresql.org (Postfix) with ESMTP id DCBFF3A3FA8 for ; Tue, 16 Nov 2004 15:11:09 +0000 (GMT) Received: from [192.168.1.20] ([192.168.1.20]:49160 "EHLO daytonnt20.oneilinc.net" ident: "NO-IDENT-SERVICE[2]") by meridius.oneil.com with ESMTP id ; Tue, 16 Nov 2004 10:11:09 -0500 Received: from DAYTONEX.oneilinc.net (unverified) by daytonnt20.oneilinc.net (Content Technologies SMTPRS 4.3.14) with ESMTP id for ; Tue, 16 Nov 2004 10:07:21 -0500 X-MIMEOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4CBED.F8C958B5" Subject: Re: Table definition Date: Tue, 16 Nov 2004 10:07:21 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] Table definition Thread-Index: AcTL5wmva8bnkgvQSjy1fwb3iL1EnwABrbww From: "Goutam Paruchuri" To: =?iso-8859-1?Q?Bruno_Pr=E9vost?= , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_FONTCOLOR_BLUE, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200411/146 X-Sequence-Number: 19465 This is a multi-part message in MIME format. ------_=_NextPart_001_01C4CBED.F8C958B5 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Probably there is no direct way get the definition (i could not find one at= least). You can probably write a custom function which gives all columns, indexes a= nd formulate a create table statement (text definition). =20 Let us know if you find a way out. =20 - Goutam =20 ________________________________ From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.or= g] On Behalf Of Bruno Pr=E9vost Sent: Tuesday, November 16, 2004 9:04 AM To: pgsql-sql@postgresql.org Subject: [SQL] Table definition =09 =09 =20 Hi, Anybody know how to obtain the table definition in text. Something like "select definition from pg_catalog.pg_views where viewname = =3D 'xxx'" but for a table. Thanks Bruno =20 Confidentiality Notice The information contained in this e-mail is confidential and intended for u= se 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 distributio= n of this communication, other than by the intended recipient, is strictly = prohibited. ------_=_NextPart_001_01C4CBED.F8C958B5 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Les consultants Interaction | stationery
Probably there is no direct way get the definition= (i could=20 not find one atleast).
You can probably write a custom function which giv= es all=20 columns, indexes and formulate a create table statement (text=20 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=20 Pr=E9vost
Sent: Tuesday, November 16, 2004 9:04 AM
To:=20 pgsql-sql@postgresql.org
Subject: [SQL] Table=20 definition

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


Confidentiality Notice
The information contained in this e-mail is confidential and intended for u= se 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 distributio= n of this communication, other than by the intended recipient, is strictly = prohibited.
 ------_=_NextPart_001_01C4CBED.F8C958B5--