PG 8.0beta: psql suggestion - Mailing list pgsql-general

From Eric B.Ridge
Subject PG 8.0beta: psql suggestion
Date
Msg-id FC9B23B7-EBD2-11D8-AE5C-000A95BB5944@tcdi.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: [HACKERS] Coming soon: PG 7.4.4, 7.3.7, 7.2.5
Next
From: Tom Lane
Date:
Subject: Re: Changing from base type to inherited