2 ms·
You're right. I wish schema wasn't such an overloaded term :) In order to access either the old or new version of the schema, applications should configure the
by surjection 3y ago
You're right. I wish schema wasn't such an overloaded term :)
In order to access either the old or new version of the schema, applications should configure the Postgres `search_path`[0] which determines which schema and hence which views of the underlying tables they see.
This is touched on in the documentation here[1], but could do with further expansion.
[0] - https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH https://www.postgresql.org/docs/current/ddl-schemas.html#DDL...
[1] - https://github.com/xataio/pgroll/blob/main/docs/README.md#client-applications https://github.com/xataio/pgroll/blob/main/docs/README.md#cl...
- dkubb 3y agoI mentally change schema to namespace when thinking about the postgresql feature.
- guffins 3y agoYou’re not alone. That’s also how PostgreSQL itself thinks about schemas! https://www.postgresql.org/docs/current/catalog-pg-namespace.html https://www.postgresql.org/docs/current/catalog-pg-namespace...