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). Dmitry