Thread

  1. Re: [HACKERS] Re: Failure to show descriptions in \df command

    Bruce Momjian <maillist@candle.pha.pa.us> — 1999-11-13T18:19:19Z

    > 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 on
    	test=> \dT
    	ERROR:  Relation 'p' does not exist
    
    
    Also, the \set commands don't seem to complain about bad commands:
    
    	test=> \set figgle
    	test=> 
    
    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, Pennsylvania 19026