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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers