PostgreSQL: Databases vs Schemas
Jump to navigation Jump to search
Some consideration when designing databases vs schemas in the Postgres Database are:
- Communicating ownership of database is easier at a database-level
- Access Control
- Postgres provides fine-grain control of database objects down to the table level.
- Schemas provide improved flexibility of joining data as it still resides within the same database.