[postgis-users] Re : Re : Re : Re : PosGISViewer plugin PgAdmin III

[jrmrolland at aol.com]

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 <bruno at ioda-net.ch>
A : PostGIS Users Discussion <postgis-users at postgis.refractions.net>
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, jrmrolland at aol.com 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

postgis-users at postgis.refractions.net

http://postgis.refractions.net/mailman/listinfo/postgis-users


 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100611/1afc32fb/attachment.html>