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 3C2BA3A40C0 for ; Tue, 16 Nov 2004 15:29:32 +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 67477-07 for ; Tue, 16 Nov 2004 15:29:22 +0000 (GMT) Received: from outmail.freedom2surf.net (outmail1.freedom2surf.net [194.106.33.237]) by svr1.postgresql.org (Postfix) with ESMTP id 5E0AA3A40BC for ; Tue, 16 Nov 2004 15:29:24 +0000 (GMT) Received: from sam.samason.me.uk (sam.samason.me.uk [195.137.31.118]) by outmail.freedom2surf.net (8.12.10/8.12.10) with ESMTP id iAGFTNnF026714 for ; Tue, 16 Nov 2004 15:29:23 GMT Received: by sam.samason.me.uk (Postfix, from userid 1000) id 5F8EA636BB; Tue, 16 Nov 2004 15:29:23 +0000 (GMT) Date: Tue, 16 Nov 2004 15:29:23 +0000 From: Sam Mason To: pgsql-sql@postgresql.org Subject: Re: Table definition Message-ID: <20041116152923.GY25775@sam.samason.me.uk> Mail-Followup-To: pgsql-sql@postgresql.org References: <02ac01c4cbe5$2effc580$5d00a8c0@BRUNO2500> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <02ac01c4cbe5$2effc580$5d00a8c0@BRUNO2500> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/148 X-Sequence-Number: 19467 Bruno Prévost wrote: >Anybody know how to obtain the table definition in text. Not quite sure if this is quite what you're after, but would: $ pg_dump -st foo help at all? It gives out the SQL that you would need to enter to re-create the table. Sam