ok, for me (and for the PostGISViewer plugin) the geometry_columns table is 
always in the public schema, 
so if $$SCHEMA=userdata (your schema), you don't have to pass 2 schema, but 
only your schema if you 
select a table.
For a query you must specifiy the schema with the table name like this :
SELECT * FROM userdata.your_table

 


 Jérôme

 

-----E-mail d'origine-----
De : Bruno Friedmann <[email protected]>
A : PostGIS Users Discussion <[email protected]>
Envoyé le : Vendredi, 11 Juin 2010 13:38
Sujet : Re: [postgis-users] Re : Re : Re : PosGISViewer plugin PgAdmin III


On 06/11/2010 01:19 PM, [email protected] wrote:

> yes of course, public is just an sample, you can specifiy another schema if 

you want.

> 

> 

> Jérôme

> 



but the question is : we need to pass 2 schemas as public contain 

geometry_columns table and userdata the table containing data ...

did this work also on a actual running installation



(Sorry didn't have any windows here ... )



-- 



     Bruno Friedmann

_______________________________________________

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

Reply via email to