On 7/11/19 6:54 AM, bhargav kamineni wrote:
> Hi Team,
>
> I have a doubt regarding the extensions.My db has these many extensions > Name
> -------------------
> adminpack
> btree_gist
> dblink
> file_fdw
> fuzzystrmatch
> hstore
> insert_username
> intarray
> pageinspect
> pg_buffercache
> pg_freespacemap
> pg_repack
> pg_stat_statements
> pg_trgm
> pgcrypto
> plpgsql
> unaccent
I'm assuming the above came from using \dx in psql.
>
>
> How can i figure out what all extensions are being used ? is there any way ?
One quick and dirty way I know is:
test=# begin ;
BEGIN
test=# drop extension plpgsql ;
ERROR: cannot drop extension plpgsql because other objects depend on it
DETAIL: function upgrade_serial_to_identity(regclass,name) depends on
language plpgsql
function fizzbuzz(integer,integer) depends on language plpgsql
function child_fnc() depends on language plpgsql
function child_fnc(character varying) depends on language plpgsql
function parent_fnc() depends on language plpgsql
...
rollback;
>
> Thanks,
> Bhargav
--
Adrian Klaver
adrian.klaver@aklaver.com
