2 ms·
Ah, interesting ok > You can have the same table definition, within the same database, defined multiple times (each in a different schema) and each holding dif
by pickledish 3y ago
Ah, interesting ok
> You can have the same table definition, within the same database, defined multiple times (each in a different schema) and each holding different data.
So in this respect, each table within a schema indeed already acts like a "shard" of the overall table
Is this enforced? Like, if I create a table "messages" in schema A and a table "messages" in table B, must they have the same columns/column types, or is that just convention
- mulander 3y agoThey can be different, as long as your application can handle them being different (which makes sense for microservices as an example).
- pickledish 3y agoI see! Fascinating, thanks for the help :)