extensions and psql

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема extensions and psql
Дата
Msg-id m2fwrpfe4v.fsf@2ndQuadrant.fr
обсуждение исходный текст
Ответы Re: extensions and psql  (Robert Haas <robertmhaas@gmail.com>)
Re: extensions and psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Sync Rep for 2011CF1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: sepgsql contrib module