Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 1974A2E002C
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Wed,  9 Apr 2008 11:21:39 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 97160-02
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Wed,  9 Apr 2008 11:21:32 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from wf-out-1314.google.com (wf-out-1314.google.com
 [209.85.200.169])
	by developer.postgresql.org (Postfix) with ESMTP id E16C62E0050
	for <pgsql-admin@postgresql.org>; Wed,  9 Apr 2008 11:21:33 -0300 (ADT)
Received: by wf-out-1314.google.com with SMTP id 28so2489055wff.28
	for <pgsql-admin@postgresql.org>; Wed, 09 Apr 2008 07:21:32 -0700 (PDT)
Received: by 10.143.159.11 with SMTP id l11mr48596wfo.186.1207750892203;
	Wed, 09 Apr 2008 07:21:32 -0700 (PDT)
Received: by 10.143.196.2 with HTTP; Wed, 9 Apr 2008 07:21:32 -0700 (PDT)
Message-ID: <9b1af80e0804090721l42e45f09p37ce25ff39e87832@mail.gmail.com>
Date: Wed, 9 Apr 2008 18:21:32 +0400
From: "Vyacheslav Kalinin" <vka@mgcp.com>
To: spotluri@ismartpanache.com
Subject: Re: How do i get DDL of a Table from system catalog ?
Cc: pgsql-admin@postgresql.org
In-Reply-To: <41734.1207749044@ismartpanache.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4363_17509020.1207750892229"
References: <41734.1207749044@ismartpanache.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/91
X-Sequence-Number: 28855

------=_Part_4363_17509020.1207750892229
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

try starting psql with -E (would show queries psql does) option and \d+ the
table

------=_Part_4363_17509020.1207750892229
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

try starting psql with -E&nbsp;(would&nbsp;show&nbsp;queries&nbsp;psql&nbsp;does) option and \d+ the table<br><br><br><br>

------=_Part_4363_17509020.1207750892229--