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

[Majid Kazemi]

Thanks for your help.  

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Pavel Iacovlev
Sent: March 11, 2010 12:26 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] database and schema in Postgres/Postgis

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users