PostgreSQL: Databases vs Schemas

From Glitchdata
Jump to navigation Jump to search

Some consideration when designing databases vs schemas in the Postgres Database are:

  1. Ownership
    • Communicating ownership of database is easier at a database-level
  2. Access Control
    • Postgres provides fine-grain control of database objects down to the table level.
  3. Referencing
    • Schemas provide improved flexibility of joining data as it still resides within the same database.
  4. Performance