[postgis-users] Proper usage of Schema's

[aperi2007]

Hi,

The esri world work always in an unique DB schema.
So a single "dataset" is a group of tables in the same schema of the 
other datasets.


I don't understand why you need to use distinct schemas to separate they.

However I think you could do it.

You must install postgis in the "public" schema but
of course you can create and insert gis data in other schemas
setting correctly the search_path and the grants.

So I guess you could create a schema
"hydrography" and a schema "roads" and a schema "boundaries".
And (i guess) you could define some relational foreign key between
a table in the hydrography schema and a table in the boundaries schema.

AFAIK I don't know if this is a correct mimic for esri world, more again 
I don't know if esri allow to define a foreign constraint between two 
distinct datasets, but I guess this is a good use for the schemas in a 
postgres+postgis DB.



Regards,
Andrea.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] Proper usage of Schema's

[Tomas_Lopes]

Hello all,
I have been using PostGIS personally for years but now need to do a
professional instance in an environment used to accessing data within Esri
File GDBs.  They are caught up on "Datasets" for organization.  I
understand
their point and I am trying to support this.
My Question is this:  Can I use Schemas as a way to seperate the data into
"datasets" to mimic the Esri organization?  is this a proper use of
schema's
within PostGIS?  If not, any alternatives that might mimic the Esri
Datasets
functionality?
THnaks so much in advance.

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users