Re: \d output to a file

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