Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] \d output to a file

From: Ragnar HafstaĆ° <gnari(at)simnet(dot)is>
To: sarlav kumar <sarlavk(at)yahoo(dot)com>
Cc: pgsqlnovice <pgsql-novice(at)postgresql(dot)org>,pgsqlperform <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] \d output to a file
Date: 2004-12-15 18:23:43
Message-ID: 1103135023.4086.8.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
On Wed, 2004-12-15 at 11:50 -0500, Tom Lane wrote:
> Geoffrey <esoteric(at)3times25(dot)net> 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



In response to

pgsql-novice by date

Next:From: John DeSoiDate: 2004-12-15 20:09:56
Subject: Re: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X
Previous:From: Andrew LazarusDate: 2004-12-15 18:05:49
Subject: Re: [PERFORM] Query Optimization

pgsql-performance by date

Next:From: Josh BerkusDate: 2004-12-15 18:25:02
Subject: Re: Partitioned table performance
Previous:From: Andrew LazarusDate: 2004-12-15 18:05:49
Subject: Re: [PERFORM] Query Optimization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group