pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedExtensions and schema
2+ messages / 2 participants
[nested] [flat]
* Extensions and schema
@ 2025-02-14 04:43 Edwin UY <edwin.uy@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Edwin UY @ 2025-02-14 04:43 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Extensions and schema
@ 2025-02-14 05:28 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Edwin UY <edwin.uy@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2025-02-14 05:28 UTC (permalink / raw)
To: Edwin UY <edwin.uy@gmail.com>; pgsql-admin@lists.postgresql.org
On Fri, 2025-02-14 at 17:43 +1300, Edwin UY wrote:
> Just curious, does the Schema 'owner' matter unde \dx ? Or is it decided during
> the CREATE EXTENSION in the background depending on the extension?
The schema must already exist when you create an extension in it, and
CREATE EXTENSION does not affect the ownership or permissions on the
schema.
Yours,
Laurenz Albe
--
*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.
*CONFIDENTIALITY NOTICE & DISCLAIMER
*This message and any attachment are
confidential and may be privileged or otherwise protected from disclosure
and solely for the use of the person(s) or entity to whom it is intended.
If you have received this message in error and are not the intended
recipient, please notify the sender immediately and delete this message and
any attachment from your system. If you are not the intended recipient, be
advised that any use of this message is prohibited and may be unlawful, and
you must not copy this message or attachment or disclose the contents to
any other person.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-02-14 05:28 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-14 04:43 Extensions and schema Edwin UY <edwin.uy@gmail.com>
2025-02-14 05:28 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox