Subject Re: Schema pluses?
Author Dmitry Yemanov
13.06.2016 00:18, 'livius' wrote:
> what are + and – with working with schema?
> What benefits are between
> schema_name__table_name and real schema implementation?
> schema_name.table_name

Ability to have a default schema (per user, per connection). So that you
may have multiple completely unrelated databases inside single physical
database, and set up multiple "schema-less" users/applications of these
different logical databases. E.g. one app works with USERS but actually
it's CRM.USERS and a different app also works with USERS but actually
it's HR.USERS. From the maintenance/administration POV it's a single
database (configuration, backups, etc).