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.kla...@aklaver.com
