Re: \d+ for long view definitions? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: \d+ for long view definitions?
Date
Msg-id 1256856086.9673.2.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: \d+ for long view definitions?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: \d+ for long view definitions?
List pgsql-hackers
On tis, 2009-09-01 at 14:29 -0400, Tom Lane wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
> > I think we should always or never show the view definition, not sometimes.
> 
> Yeah.  I can live with \d not showing it and \d+ showing it --- as Peter
> already mentioned, that would be consistent with \df behavior.  Making
> it depend on the length is just weird.

The patch for this endeavor is:

diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -1306,7 +1306,7 @@ describeOneTableDetails(const char *schemaname,       printTableAddHeader(&cont, headers[i],
true,'l');
 
   /* Check if table is a view */
-   if (tableinfo.relkind == 'v')
+   if (tableinfo.relkind == 'v' && verbose)   {       PGresult   *result;

Any final words?



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Syntax for partitioning
Next
From: Peter Eisentraut
Date:
Subject: grant with hierarchy option