X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 53DDA3B4022; Wed, 15 Dec 2004 18:23:47 +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 55838-08; Wed, 15 Dec 2004 18:23:43 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id 997A63B352D; Wed, 15 Dec 2004 18:23:42 +0000 (GMT) Received: from gnari ([157.157.184.21] [157.157.184.21]) by quasar.skima.is with ESMTP; Wed, 15 Dec 2004 18:23:40 Z Subject: Re: [PERFORM] \d output to a file From: Ragnar =?ISO-8859-1?Q?Hafsta=F0?= To: sarlav kumar Cc: pgsqlnovice , pgsqlperform In-Reply-To: <2441.1103129458@sss.pgh.pa.us> References: <20041215143822.37534.qmail@web51304.mail.yahoo.com> <41C05576.7030703@3times25.net> <2441.1103129458@sss.pgh.pa.us> Content-Type: text/plain Date: Wed, 15 Dec 2004 18:23:43 +0000 Message-Id: <1103135023.4086.8.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/155 X-Sequence-Number: 11732 On Wed, 2004-12-15 at 11:50 -0500, Tom Lane wrote: > Geoffrey writes: > > sarlav kumar wrote: > >> I would like to write the output of the \d command on all tables in a > >> database to an output file. > > > What is the OS? On any UNIX variant you can do: > > echo '\d' | psql > outputfile > > Or use \o: > > regression=# \o zzz1 > regression=# \d or: =# \d * to get all tables as th OP wanted > regression=# \o gnari