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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2004-12-15 20:09:56 | Re: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X |
Previous Message | Andrew Lazarus | 2004-12-15 18:05:49 | Re: [PERFORM] Query Optimization |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2004-12-15 18:25:02 | Re: Partitioned table performance |
Previous Message | Andrew Lazarus | 2004-12-15 18:05:49 | Re: [PERFORM] Query Optimization |