Re: Failure to show descriptions in \df command

From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Failure to show descriptions in \df command
Date: 1999-11-13 17:15:53
Message-ID: Pine.GSO.4.02A.9911131804490.606-100000@Val.DoCS.UU.SE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

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.).

Read the fine (SGML) manual ;)

-Peter

On Sat, 13 Nov 1999, Bruce Momjian wrote:

> Peter, I no longer see the pg_description descriptions when using the
> \do, \df, and \dT commands.
>
> The commands are much less useful without the descriptions. Seems \dd
> with a string is much smarter, and pulls descriptions based on string
> matching.
>
> Interesting that \dd shows descriptions of everything.
>
> Not sure how to recommend you change this. The new \df and \do
> displays are much clearer without the descriptions. It seems \df and
> \do show additional information about argument types and return values,
> while \dd shows comments.
>
> Maybe just add descriptions to \dT, and suggest people use \dd to get
> info about specific operators of functions? But that kind of messes the
> clarity of using \dd for descriptions.
>
> I am stumped. Maybe it can't be improved.
>
>

--
Peter Eisentraut Sernanders vaeg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-11-13 18:19:19 Re: [HACKERS] Re: Failure to show descriptions in \df command
Previous Message Keith Parks 1999-11-13 17:15:28 Re: [HACKERS] translate function (BUG?)