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
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

In response to

Browse pgsql-novice by date

  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

Browse pgsql-performance by date

  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