[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