psql available extensions code example

Example: postgresql list extensions

Postgres Shell:

\dx

SQL:

SELECT * FROM pg_extension