Re: psql: Add \dL to show languages

Hi all,

I've updated the patch to address the following points:
 * help string now says "list procedural languages" (no parentheses now)
 * the language name column is now titled "Name"
 * added another column in verbose mode for 9.0+ showing whether DO
blocks are possible with the language. I named this column "DO
Blocks?", though am open to suggestions
 * fixed the whitespace problems Andreas noticed with the SELECT query

Looking at the verbose output, which looks something like this:

                                                         List of languages
   Name    | Owner | Trusted |      Call Handler       |
Validator        | System Language | DO Blocks?
 | Access privileges
-----------+-------+---------+-------------------------+------------------------+-----------------+-----------
-+-------------------
 plpgsql   | josh  | t       | plpgsql_call_handler()  |
plpgsql_validator(oid) | f               | t
 |
 plpythonu | josh  | f       | plpython_call_handler() | -
         | f               | t
 |
(2 rows)

I have a hard time imagining users who would find "Call Handler" or
"Validator" useful. This was in Fernando's original patch, and I just
didn't bother to take it out. If others feel the same way, I'd be
happy to rip those columns out.

Few more comments below:

On Mon, Jan 17, 2011 at 3:51 PM, Andreas Karlsson <andreas@proxel.se> wrote:
> On Sun, 2011-01-16 at 22:32 -0500, Josh Kupershmidt wrote:
>> On Sat, Jan 15, 2011 at 8:26 PM, Andreas Karlsson <andreas@proxel.se> wrote:
>> > Should we include a column in \dL+ for the laninline function (DO
>> > blocks)?
>>
>> Hrm, I guess that could be useful for the verbose output at least.
>
> Magnus Hagander agreed with that idea and added that for that we need to
> check the version. The column was added in 9.0 if I recall.

Added.

[snip]

> * Missing indentation before ACL column, the other functions have it.
> * One space before FROM instead of one newline like the other queries.
> * The space before ORDER BY.

These should be fixed now.

> That's enough nitpickery for now. :)

I spend enough of my time nitpicking others. Turnabout is fair play :)

Thanks for all the review and feedback from everyone.

Josh