How to update all PostgreSQL extensions installed in the database?

Question

PostgreSQL

You need to update all extensions, not just one. Perhaps this command is useful for this, it shows installed extensions: SELECT * FROM pg_extension

Answer 1

1. generate requests:

select 'alter extension ' || e.extname || ' update;' FROM pg_catalog.pg_extension e;

2. fulfill these requests. \gexec , for example in psql.