3 ms·
See also: https://www.postgresql.org/docs/12/ddl-schemas.html#DDL-SCHEMAS-PATTERNS https://www.postgresql.org/docs/12/ddl-schemas.html#DDL-SCHE... In particula
by e12e 6y ago
See also:
https://www.postgresql.org/docs/12/ddl-schemas.html#DDL-SCHEMAS-PATTERNS https://www.postgresql.org/docs/12/ddl-schemas.html#DDL-SCHE...
In particular, note the justification for the default:
> Keep the default. All users access the public schema implicitly. This simulates the situation where schemas are not available at all, giving a smooth transition from the non-schema-aware world. However, this is never a secure pattern. It is acceptable only when the database has a single user or a few mutually-trusting users.
And:
https://www.postgresqltutorial.com/postgresql-schema/ https://www.postgresqltutorial.com/postgresql-schema/