From: | Edwin UY <edwin(dot)uy(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Extensions and schema |
Date: | 2025-02-14 04:43:16 |
Message-ID: | CA+wokJ8_KAVXGmChZXVbt7nMo-1f2CYVNNcFjwAyj--0o=74+A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Edwin UY | 2025-02-14 04:45:06 | Create a Database or a Schema -- when to do what? |
Previous Message | Yogesh Sharma | 2025-02-13 19:09:23 | Re: repmgr, pgpool install on amazon linux 2023? |