Re: To do for psql to show installable extensions

On Mon, Jan 12, 2015 at 01:05:16PM -0800, Jeff Janes wrote:
> I'd like to propose a wiki to-do item for a backslash command in psql which
> would show all installable extensions, basically just a wrapper around
> 'select * from pg_available_extensions'.
>
> I've wanted it a few times recently, mostly in testing.

If your psql has libreadline, you can CREATE EXTENSION <tab><tab> and
get a list. It doesn't distinguish between installed ones and
available, though.

> Any reason this wouldn't be desirable? What should it be called? I thought
> of \dx+, but the + is already used to show the objects associated with the
> extensions. (Althought it seems like it would more in keeping with other
> usage if \dx+ only listed the objects if it was given a pattern, and did
> what I propose if given no pattern)

For what it's worth, of the proposals so far, I like \dxa most.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate