Extensions and schema

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

Responses

Browse pgsql-admin by date

  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?