Just curious, does the Schema 'owner' matter unde \dx ? Or is it decided during the CREATE EXTENSION in the background depending on the extension?
List of installed extensions
Name | Version | Schema | Description --------------------+---------+------------+----------------------------------------------------------- pg_stat_statements | 1.10 | public | track execution statistics of all SQL statements executed pgaudit | 1.4 | public | provides auditing functionality plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language (3 rows)
List of installed extensions Name | Version | Schema | Description --------------------+---------+------------+----------------------------------------------------------- pg_stat_statements | 1.10 | public | track execution statistics of all SQL statements executed pglogical | 2.4.4 | pglogical | PostgreSQL Logical Replication plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(3 rows)
- And this one has Schema as joe which is a Role/User -- YES, I manually change the actual name to joe
List of installed extensions Name | Version | Schema | Description --------------------+---------+------------+----------------------------------------------------------- pg_stat_statements | 1.7 | public | track execution statistics of all SQL statements executed pgcrypto | 1.3 | joe | cryptographic functions plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
