Hacker News new | ask | show | jobs
by pickledish 1067 days 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

1 comments

They can be different, as long as your application can handle them being different (which makes sense for microservices as an example).
I see! Fascinating, thanks for the help :)