Re: [PERFORM] [NOVICE] \d output to a file

2004-12-15 Thread Ragnar HafstaĆ°
On Wed, 2004-12-15 at 11:50 -0500, Tom Lane wrote: > 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

Re: [PERFORM] [NOVICE] \d output to a file

2004-12-15 Thread Tom Lane
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 re

Re: [PERFORM] [NOVICE] \d output to a file

2004-12-15 Thread Geoffrey
sarlav kumar wrote: Hi All, I would like to write the output of the \d command on all tables in a database to an output file. There are more than 200 tables in the database. I am aware of \o command to write the output to a file. But, it will be tough to do the \d for each table manually and write