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

kreshna_iceheart at yahoo.com kreshna_iceheart at yahoo.com
Tue Mar 25 02:29:56 PDT 2008

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?
  Many thanks,
  - Kresh

So be it. If saying "NO" means being alone, then to hell with love, with women, with marriage, with God, religions, bars, nightclubs, computer games, and all the shit life keeps pumping at me. I'll walk alone, but with freedom and a healed pride.
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080325/4aa362df/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: lack-of-geometry-objects-in-bali-schema.jpg
Type: image/pjpeg
Size: 131241 bytes
Desc: 2937095119-lack-of-geometry-objects-in-bali-schema.jpg
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080325/4aa362df/attachment.bin>

More information about the postgis-users mailing list