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

Reply via email to