4 ms·
What do you mean multiple schemas ? What is an example of a non readable type?
by Exuma 3y ago
What do you mean multiple schemas ? What is an example of a non readable type?
- pimeys 3y agoLike this, it's pretty common way to use Postgres (with multiple schemas): CREATE SCHEMA a; CREATE SCHEMA b; CREATE TABLE a.foo (id SERIAL PRIMARY KEY); CREATE TABLE b.foo (id SERIAL PRIMARY KEY);
- xctr94 3y agoI didn’t know support for schemas had landed, but the docs still seem obtuse for joins and upserts. Compared to plain SQL files in PgTyped — which admittedly needs some annotations to work, and lacks transactions —, I find the lateral joins in Zapatos really verbose and ugly. Lots of extra parameters too. Which isn’t to say it’s not a great tool! You pick what you like :)
- alde 3y agoGlad you are liking pgTyped. Transactions are supported as pgTyped is just a thin wrapper around node-postgres: https://github.com/adelsz/pgtyped/discussions/448 https://github.com/adelsz/pgtyped/discussions/448
- xctr94 3y agoAh, I meant having a single transaction in a SQL file, as that’s how we’re using it. So having multiple queries with a BEGIN and COMMIT wrapping them.