On Jan 28, 2006, at 3:20 PM, Rich Shepard wrote:
contacts=# \d | less
\d: extra argument "less" ignored
You can't do this via the psql prompt. A simple "\d" will output to
the screen, automatically using your $PAGER if the output is too long
to fit on your screen.
I can, however, run '\dt' and have it page normally. But, I
cannot write
that output to a file using redirection or the tee command:
contacts=# \dt > xrms.tables
No matching relations found.
\dt: extra argument "xrms.tables" ignored
Again, you can't use redirection via the psql prompt. But you can do
it via your shell command line:
$ psql -c "\dt" > xrms.tables
Alternatively, you can use psql's "\o [FILE]" command to redirect
query results to a file:
contacts=# \o /tmp/xrms.tables
contacts=# \dt
contacts=#
That'll send all output to /tmp/xrms.tables.
I'll be sure to read that section. The \dt and \di commands show
me what I
want, but I cannot redirect output to a file. What am I still missing,
please?
You should also read the psql man page and the output of psql's "\h"
command.
eric
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
