Absolutely. In this way all new postgis databases created from this
template will have the same functionality. I also install other
commonly used modules (like cube, btree gist) or custom functions into
the template_postgis database as well.
-- Kevin
George Silva wrote:
when i create a postgis database i use a clean template_postgis
database (create at time of instalation) as template. Is this a ok /
correct practice?
Att.
George
Nicolas Ribot escreveu:
I'm planning to use database schemas to organize my spatial tables. For
example, all spatial tables of GIS objects belong to Bali island is
to be
kept in a schema named "bali", etcetera.
Problem is, when I created a new schema named bali, it did not
inherit all
the postGIS objects of the public schema.
As you can see on the attached screenshot (I'm using pgAdmin III), the
public schema contains all the Aggregates, Domains, Functions,
etcetera,
which are all part of postGIS functionality. Examples are geomunion
function
and earth domain, which exist in the public schema but do not exist
on bali
schema.
Can I use bali schema to store postGIS tables then? Or should I copy
all the
postGIS Aggregates, Domains, Functions, etc, to the bali schema in
order to
make it work? And if that's the case, anyone know the easiest way to
do so?
Postgis functions should stay in the public schema. No need to copy
them.
You will be able to use them on the bali.* tables by either fully
qualifying the tables' name in your queries or by adding your newly
created schema to the search path (no need to qualify tables names
with the schema in this case)
Nicolas
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
