An overview of the geodatabase schema in PostgreSQL
An overview of the geodatabase schema in PostgreSQL
Release 9.3
Note:This topic was updated for 9.3.1.
PostgreSQL is an open source database management system (DBMS).
Geodatabases stored in a PostgreSQL DBMS have system tables, which are created and maintained in the schema of the ArcSDE administrator.* If you install PostGIS, there are also a few system tables in the public schema. These system tables maintain information about, and manage the data in, the geodatabase.
Geodatabases stored in PostgreSQL also contain user-defined datasets such as feature classes and raster catalogs. These tables store the spatial and attribute information of your GIS data. User-defined datasets are stored in the default schema of the user who creates them. It is recommended that user-defined datasets not be stored in the ArcSDE administrator's schema; therefore, you should use another user name to connect to the geodatabase when you are creating datasets.
The other topics in this section describe both the user-defined and system tables found in a geodatabase in PostgreSQL.
*The only exception to this is the sde_spatial_references table, which is stored in the public schema.
