Re: \d output to a file

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: \d output to a file
Дата
Msg-id 2441.1103129458@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: \d output to a file  (Geoffrey <esoteric@3times25.net>)
Ответы Re: \d output to a file  (Kretschmer Andreas <andreas_kretschmer@despammed.com>)
Re: [PERFORM] \d output to a file  (Ragnar Hafstað <gnari@simnet.is>)
Список pgsql-novice
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
regression=# \o
regression=# \d
             List of relations
 Schema |     Name      | Type  |  Owner
--------+---------------+-------+----------
 public | pg_ts_cfg     | table | postgres
 public | pg_ts_cfgmap  | table | postgres
 public | pg_ts_dict    | table | postgres
 public | pg_ts_parser  | table | postgres
 public | t_test        | table | postgres
 public | test_tsvector | table | postgres
(6 rows)

regression=# \q
$ cat zzz1
             List of relations
 Schema |     Name      | Type  |  Owner
--------+---------------+-------+----------
 public | pg_ts_cfg     | table | postgres
 public | pg_ts_cfgmap  | table | postgres
 public | pg_ts_dict    | table | postgres
 public | pg_ts_parser  | table | postgres
 public | t_test        | table | postgres
 public | test_tsvector | table | postgres
(6 rows)

$

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: Kretschmer Andreas
Дата:
Сообщение: Re: [despammed] \d output to a file
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: function returning a row