Hallo List,
I am bit stuck as a postgresql newbie with the definition of schemas. I am
setting up a geodatabase with postgis under windows plattform - wapp strategy -
and I would like to have several schemas within one database. Schema names
should corresponde to the name of a group roles each having several single
users.
1. Is it possible to work with group roles and schemas in this context ?
2. What is the typical workflow when someone sets up a database with different
schema in (one) database ?
3. Is the following workflow suitable ?
3.1 createdb -U postgres -T postgis_template mygeodatabase
3.2 pg_dump --file=mygeodatabase.sql --format=p --schema=public
--schema-only -U postgres
3.3 Open mygeodatabase.sql in editor search and replace schema 'public' with
'newschema'
3.4 Import new schema to mygeodatabase with psql -d mygeodatabase -f
c:\my\path\mygeodatabase.sql -U postgres (or new user)
and then how to import new data to newschema.mygeodatabase ?
Are they further issues to keep in mind (e. g. set search_path to newuser) ?
I think there must be better ways to create new schema and to import data in my
geodatabase.
How does it suits to postgis ? See example...
select AddGeometryColumn (<schema_name>, <table_name>, <column_name>, <srid>,
<geometrytype>, <dimension>);
Thanks a lot for corresponding
Joe
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
