extensions and psql

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: extensions and psql
Date: 2011-02-15 16:37:04
Message-ID: m2fwrpfe4v.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I realize that you didn't keep the \dx behavior I had, that when given
an extension name it would list all the objects contained in the
extension. Now that's a pretty simple query:

select pg_describe_object(classid, objid, 0)
from pg_depend d
join pg_extension e on d.refclassid = e.tableoid
and d.refobjid = e.oid
and d.deptype = 'e'
where e.extname = 'hstore'
order by objid;

Do we want to get that back in, and in which psql command? It could
well be that having \dx list extension and \dx name list extension's
objects wasn't the best design around, and it could be that it's not
useful enough, but I know I liked to have a psql shortcut to do that.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-02-15 16:41:47 Re: sepgsql contrib module
Previous Message Simon Riggs 2011-02-15 16:29:28 Re: Sync Rep for 2011CF1