Re: [HACKERS] Re: Failure to show descriptions in \df command - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Re: Failure to show descriptions in \df command
Date
Msg-id 199911131819.NAA27752@candle.pha.pa.us
Whole thread Raw
In response to Re: Failure to show descriptions in \df command  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
List pgsql-hackers
> You can turn the descriptions on by typing \set description on (or \set
> description foo, or whatever, as long as it's something), for example, in
> your ~/.psqlrc (or in your .psqlrc-7.0.0 if you don't want to interfere
> with the current version).

OK. I noticed that the existance of an .psqlrc file causes an extra
newline to be printed on startup before the first prompt.  Is that
intentional?

> 
> The reason for having descriptions off by default was that in a number of
> views (I recall functions and operators), they don't fit on the screen
> very nicely. On the other hand, the \dd command always shows descriptions,
> because it's sort of the built-in manual, but it doesn't show anything
> else (argument types, etc.).

Got it.  Yes, much clearer for \df and \do.  I noticed that using \set
description on and then using \dT generates an error of:test=> \set description ontest=> \dTERROR:  Relation 'p' does
notexist
 


Also, the \set commands don't seem to complain about bad commands:
test=> \set figgletest=> 

Is that intentional?

> 
> Read the fine (SGML) manual ;)
> 

That was part of my problem.  I hadn't figured out how to generate html
from the sgml ref stuff.  I just spent some time and figured out I have
to issue the 'make' command from the upper sgml directory because there
is no Makefile in the sgml/ref directory.  I can view them fine now.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Failure to show descriptions in \df command
Next
From: Theo Kramer
Date:
Subject: My bits moved right off the end of the world...