Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6BEDA2E2DDC for ; Thu, 15 Nov 2007 11:40:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 83010-07 for ; Thu, 15 Nov 2007 11:39:41 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 2BD612E2DB9 for ; Thu, 15 Nov 2007 11:39:59 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1Isgov-0006Qk-UA for pgsql-admin@postgresql.org; Thu, 15 Nov 2007 10:39:58 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id B1FDD504FC; Thu, 15 Nov 2007 10:39:52 -0500 (EST) Date: Thu, 15 Nov 2007 10:39:52 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: functions pg_get... Message-ID: <20071115153952.GG20228@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <1C2329C9430609409808ECF10237287612EA4CC8@mydomain.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <1C2329C9430609409808ECF10237287612EA4CC8@mydomain.com> User-Agent: Mutt/1.5.13 (2006-08-11) Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/145 X-Sequence-Number: 27388 On Thu, Nov 15, 2007 at 04:33:34PM +0100, "K=F6nig, Monika" wrote: > I'm looking for a postgres-funtion that shows me the definition of a ta= ble. In psql, this is retrieved by \d [tablename]. By running psql -E, you'll= be able to see how it generates that. (No, I'm not going to tell you, becau= se I think it's good practice :) A --=20 Andrew Sullivan Old sigs will return after re-constitution of blue smoke