I think there three ways to change your search path.
-- Will temporarily set the search path for this connection only
SET search_path TO schema1, pubic;
-- Will set the search path for the specified user for all subsequent
connection (not the current connection)
ALTER USER username SET search_path to schema1, public;
-- change the postgresql.conf file to set the search path for all users
for all subsequent connections
search_path = '"$user", schema1, public'
Cheers,
Kevin
[EMAIL PROTECTED] wrote:
Thank you, Nicolas. When I make changes to the search path, it will
stay permanent, won't it?
Regards,
-Kresh
*/Nicolas Ribot <[EMAIL PROTECTED]>/* wrote:
> I'm planning to use database schemas to organize my spatial
tables. For
> example, all spatial tables of GIS objects belong to Bali island
is to be
> kept in a schema named "bali", etcetera.
>
> Problem is, when I created a new schema named bali, it did not
inherit all
> the postGIS objects of the public schema.
>
> As you can see on the attached screenshot (I'm using pgAdmin
III), the
> public schema contains all the Aggregates, Domains, Functions,
etcetera,
> which are all part of postGIS functionality. Examples are
geomunion function
> and earth domain, which exist in the public schema but do not
exist on bali
> schema.
>
> Can I use bali schema to store postGIS tables then? Or should I
copy all the
> postGIS Aggregates, Domains, Functions, etc, to the bali schema
in order to
> make it work? And if that's the case, anyone know the easiest
way to do so?
>
Postgis functions should stay in the public schema. No need to
copy them.
You will be able to use them on the bali.* tables by either fully
qualifying the tables' name in your queries or by adding your newly
created schema to the search path (no need to qualify tables names
with the schema in this case)
Nicolas
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
__________________________________________________________________
So be it. If saying "NO" means being alone, then to hell with love,
with women, with marriage, with God, religions, bars, nightclubs,
computer games, and all the shit life keeps pumping at me. I'll walk
alone, but with freedom and a healed pride.
------------------------------------------------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo!
Search.
<http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping>
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
