Database Reference
In-Depth Information
---------+----------
postgis | postgres
public | postgres
(2 rows)
chapter10=# \d
List of relations
Schema | Name | Type |
Owner
---------+-------------------+-------+----------
postgis | geography_columns | view |
postgres
postgis | geometry_columns | view |
postgres
postgis | raster_columns | view |
postgres
postgis | raster_overviews | view |
postgres
postgis | spatial_ref_sys | table |
postgres
5. The
SET
statementinstructsPostgreSQLtoconsiderthe
public
and
post-
gis
schemaswhenprocessinganySQLstatementsfromourclientconnec-
tion.Withoutthe
SET
statement,the
\d
commandwillnotreturnanyrelation
from the
postgis
schema.
6. To prevent the need to manually use the
SET
statement every time a client
connects to the
chapter10
database, alter the database by executing the
following command:
ALTER DATABASE chapter10 SET search_path
= public, postgis;
All future connections and queries of
chapter10
will result in PostgreSQL
automatically using both
public
and
postgis
schemas.
7. LoadthePRISMrastersandSanFranciscoboundariesgeometry,whichwe
mand:
