[postgis-users] database and schema in Postgres/Postgis

Pavel Iacovlev iacovlev.pavel at gmail.com
Thu Mar 11 09:26:17 PST 2010


Add your schema to the search path

SET search_path TO myschema,public;

On Thu, Mar 11, 2010 at 7:17 PM, Majid Kazemi <Majid.Kazemi at teranet.ca> wrote:
> Hello all;
> I have created a database called mydb in postgresSQL. I run postgis and
> sys_ref_spatial scripts to populate spatial objects. All spatial objects are
>  stored in a schema called PUBLIC. I have created another  schema called
> myschema under the same database.  I can not see any of spatial objects
> generated under mydb  in my new schema. Any ideas what I should do to
> see spatail functions and tables in this new schema?
> Thanks, Majid
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



-- 
http://iap.md, The future is open



More information about the postgis-users mailing list