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.
+1. > Any reason this wouldn't be desirable? No idea. I guess if pg_available_extensions is acceptable, a \-command should be acceptable as well. But you might as well look up the old discussions that led to the current situation where we have an SRF and not a \-command. > What should it be called? \dxx / \dxi ? As long as it shows in \dx<tab> I am fine with almost anything sensible, really. > 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) I hate the pattern/no pattern discrepancy -- I vote not to propagate it any further. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers