[pgrouting-users] Table location

[Stephen Woodbridge]

On 1/27/2011 11:09 AM, Henrik Berggren wrote:
> You can have it in other schemes but you need to run the
> assign_vertex_id in the public scheme, that is my experience.

This does not really address your question, but I always setup my 
databases with postgis and pgRouting in public, but ALL my data and 
procedures ALWAYS get put in another schema like "data".

The reason for this is because, it greatly simplifies doing upgrades to 
postgis and/or pgRouting AND if I want to clone my setup to another 
system that might have a different postgis/pgRouting setup loaded on it 
then I don't run into problems.

pg_dump -N public ....

Will dump everything except "public"

Then I create an new database from a template with postgis and pgRouting 
already installed and load my data from the dump. And everything is nice 
and clean and ready to go.

-Steve W