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