Extensions and schema

Поиск

Список

Период

Сортировка

От	Edwin UY
Тема	Extensions and schema
Дата	14 февраля 07:43:16
Msg-id	CA+wokJ8_KAVXGmChZXVbt7nMo-1f2CYVNNcFjwAyj--0o=74+A@mail.gmail.com обсуждение исходный текст
Ответы	Re: Extensions and schema
Список	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

В списке pgsql-admin по дате отправления: