Thread: PG 8.0beta: psql suggestion

PG 8.0beta: psql suggestion

From
Eric B.Ridge
Date:
Been playing with the 8.0 beta of Postgres.  It seems really nice.  One
new thing I noticed is 'psql' displays RULE definitions in the \d
<viewname> output.  This is nice compared to 7.3.x's inability to see
RULE definitions at all.

However, this makes the output of \d completely useless.  Maybe my rule
definitions are atypically complex, but having 300+ lines of RULE
definitions in my face gets in the way.  The output for one particular
view fills my scrollback buffer such that I can't get to the actual
view definition!  :(

What about moving the RULE definition output to \d+?  According to the
online help, the '+' is supposed to mean "more detail".

Alternatively, maybe a new command, \dr <viewname> to list out only the
rules for the specified view (or table)?

Anyways, thanks for the hard work on 8.0.  Can't wait for it to get out
of beta!

eric