Re: [PERFORM] \d output to a file

From: Ragnar Hafstað
Subject: Re: [PERFORM] \d output to a file
Date: ,
Msg-id: 1103135023.4086.8.camel@localhost.localdomain
(view: Whole thread, Raw)
In response to: Re: \d output to a file  (Tom Lane)
List: pgsql-novice

Tree view

\d output to a file  (sarlav kumar, )
 Re: [despammed] \d output to a file  (Andreas Kretschmer, )
  Re: [despammed] \d output to a file  (Geoffrey, )
   Re: [despammed] \d output to a file  (Kretschmer Andreas, )
 Re: \d output to a file  (Geoffrey, )
  Re: \d output to a file  (Tom Lane, )
   Re: \d output to a file  (Kretschmer Andreas, )
   Re: [PERFORM] \d output to a file  (Ragnar Hafstað, )
 Re: [PERFORM] \d output to a file  (Gary Cowell, )
 Re: [PERFORM] \d output to a file  (Grega Bremec, )

On Wed, 2004-12-15 at 11:50 -0500, Tom Lane wrote:
> Geoffrey <> 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:

From: George Weaver
Date:
Subject: Re: how to echo SQL commands in the output of a script
From: Tom Lane
Date:
Subject: Re: Copying pg_control file