OK
On 12/04/2010, at 10:03 , Nicholas Bower wrote:
> 2. Dump just this separate data schema using pg_dump -Fc -N <schema>
I think here you mean -n?, but it's six of one and half a dozen of the other. I
routinely use different schema's for different aspects of the database, hence
easier to just exclude one.
> I note your solution of the separate schema using default path hack -
> interesting that this works (assume you change the search path for all db
> updater roles).
I'm not sure what you mean by this question, sorry. I do change the search_path
for the database -
ALTER database SET search_path TO data, reference, users, gis;
if that is what you are referring to?
cheers
Ben
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
