Geoffrey <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
