Re: [PERFORM] \d output to a file - Mailing list pgsql-novice

From Ragnar Hafstað
Subject Re: [PERFORM] \d output to a file
Date
Msg-id 1103135023.4086.8.camel@localhost.localdomain
Whole thread Raw
In response to Re: \d output to a file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Wed, 2004-12-15 at 11:50 -0500, Tom Lane wrote:
> Geoffrey <esoteric@3times25.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



pgsql-novice by date:

Previous
From: "candra"
Date:
Subject: Postgresql
Next
From: Robert Boone
Date:
Subject: Problem with pl/perl in postgresql 8.0rc1