[postgis-users] Do I need to copy postGIS objects to my new schema?

[Kevin Neufeld]

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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>   
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users