Re: Extensions

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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@xxxxxxxxxxx