I am new in schema concept for PostgreSQL.
For the above mentioned scenario, I was wondering
- Why don't we use a single database (with default schema named public)
- Why don't we have a single table, to store multiple users row?
- Other tables which hold users related information, with foreign key point to the user table.
Can anyone provide me a real case scenario, which single database, multiple schema will be extremely useful, and can't solve by conventional single database, single schema.