Hi,
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
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
