Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3BA922E003E for ; Wed, 27 Feb 2008 08:19:24 -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 83000-04 for ; Wed, 27 Feb 2008 08:19:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.183]) by postgresql.org (Postfix) with ESMTP id 275182E003D for ; Wed, 27 Feb 2008 08:19:14 -0400 (AST) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu0) with ESMTP (Nemesis) id 0MKwh2-1JULFf2zVi-0002Cw; Wed, 27 Feb 2008 13:19:12 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1JULFf-0000Db-00 for pgsql-sql@postgresql.org; Wed, 27 Feb 2008 13:19:11 +0100 Date: Wed, 27 Feb 2008 13:19:11 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: how do I get table DDL from psql (not from pg_dump) Message-ID: <20080227121911.GE21865@a-kretschmer.de> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX19bKMAaoBi9PXlp3TQp2HkBNQX+GF0wW1RH1/x iYQ7p1OTGgO81anl1IoKChGHzlkv8Xnp2WeMCLEZXYnI8x+9m0 VbjGqFy0wrPNWtsuRY7AVUw1VTUJGvf X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/221 X-Sequence-Number: 30312 am Wed, dem 27.02.2008, um 5:22:33 -0600 mailte Sofer, Yuval folgendes: > Hi > > > > I need to extract table DDL (create script) from database connection (using > sql, by retrieving system table info or by activating some pg function) > > > > Is this possible in postgres? Why not using pg_dump? You can specify with -n and -t an arbitrary table and with -s you get only the DDL, not the data. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net