Database Objects (cont)
A PostgreSQL installation typically has several databases.
Some catalog information is global, e.g.
- databases, users, ...
- one copy of each such table for the whole PostgreSQL installation
- shared by all databases in the installation
(lives in
PGDATA/pg_global)
Other catalog information is local to each database, e.g
- schemas, tables, attributes, functions, types, ...
- separate copy of each "local" table in each database
- a copy of many "global" tables is made on database creation
|
![[prev]](icon/prev.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}