how to view the list of extensions in postgresql code example

Example: postgresql list extensions

Postgres Shell:

\dx

SQL:

SELECT * FROM pg_extension