On Tue, Nov 24, 2009 at 5:19 PM, Kevin Neufeld <[email protected]> wrote: > So if you issued > SELECT * FROM mytable; > in this case Postgres would look first in public, then in shared, then in > project1 and then project2 for "mytable"... > > Hope this helps,
Ok. It almost helps. One thing I don't understand though -- when you say "Postgres would look first in public...," that would be in case of a query such as SELECT * FROM mytable; But, if I were to say SELECT * FROM <schema>.mytable; then all this is moot, no? I am in the habit of fully qualifying most everything, so I shouldn't have to bother with search paths, no? -- Puneet Kishor _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
