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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

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