Re: [PERFORM] \d output to a file

От: Ragnar Hafstað
Тема: Re: [PERFORM] \d output to a file
Дата: ,
Msg-id: 1103135023.4086.8.camel@localhost.localdomain
(см: обсуждение, исходный текст)
Ответ на: Re: \d output to a file  (Tom Lane)
Список: pgsql-novice

Скрыть дерево обсуждения

\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 по дате сообщения:

От: George Weaver
Дата:
Сообщение: Re: how to echo SQL commands in the output of a script
От: Tom Lane
Дата:
Сообщение: Re: Copying pg_control file