Re: Extensions

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(dot)klaver(at)aklaver(dot)com