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 327213B357F for ; Wed, 15 Dec 2004 14:38:27 +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 41571-06 for ; Wed, 15 Dec 2004 14:38:19 +0000 (GMT) Received: from web51304.mail.yahoo.com (web51304.mail.yahoo.com [206.190.38.170]) by svr1.postgresql.org (Postfix) with SMTP id 20BC03B3458 for ; Wed, 15 Dec 2004 14:38:22 +0000 (GMT) Received: (qmail 37536 invoked by uid 60001); 15 Dec 2004 14:38:22 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=yjOJ4ExKUpnrn8II9OfmhaSjoXqC+yBfDCVqRf/4GKrPWYFSrGeOGoKu17B3hrT93/jK9mk3eqYOmB5eybSr+jPRrZHqKvj5wlkraVEyFtrOZP83SqAuJyGICmA2A1n0CrnUCScNW3d2VV9I0KAFe05fTZ8HZPGYQUtORkiPrrI= ; Message-ID: <20041215143822.37534.qmail@web51304.mail.yahoo.com> Received: from [65.218.182.242] by web51304.mail.yahoo.com via HTTP; Wed, 15 Dec 2004 06:38:22 PST Date: Wed, 15 Dec 2004 06:38:22 -0800 (PST) From: sarlav kumar Subject: \d output to a file To: pgsqlnovice , pgsqlperform MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-973111891-1103121502=:36535" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.66 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_10_20, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/105 X-Sequence-Number: 11682 --0-973111891-1103121502=:36535 Content-Type: text/plain; charset=us-ascii Hi All, I would like to write the output of the \d command on all tables in a database to an output file. There are more than 200 tables in the database. I am aware of \o command to write the output to a file. But, it will be tough to do the \d for each table manually and write the output to a file. Is there a command/ way in which I can achieve this without having to do it for each table? Any help in this regard would be really appreciated. Thanks, Saranya __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-973111891-1103121502=:36535 Content-Type: text/html; charset=us-ascii
Hi All,
 
I would like to write the output of the \d command on all tables in a database to an output file. There are more than 200 tables in the database. I am aware of \o command to write the output to a file. But, it will be tough to do the \d for each table manually and write the output to a file. Is there a command/ way in which I can achieve this without having to do it for each table?
Any help in this regard would be really appreciated.
 
Thanks,
Saranya

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com --0-973111891-1103121502=:36535--