[postgis-users] st_find_extent postgresql-9.1-postgis

Tonton to.tonton at gmail.com
Wed Jul 3 07:53:18 PDT 2013


hello
i had a code that work before with postgresql-8.4-postgis (the both with
postgis 1.5)

maybe is not the best way to do it :

in python i made

cursor=connection.cursor()
    cursor.execute("SELECT st_find_extent(' " +f_table_name+ " ',' geometry
')")

to obtain the extend from table

 right now is making this request

SELECT st_find_extent('grdLyon','geometry')
but this is not working in function there is " breaking things :

ERREUR:  la relation « grdLyon » n'existe pas
LIGNE 1 : SELECT extent("geometry") FROM "grdLyon"

SELECT extent("geometry") FROM grdLyon   seems to work in pgadmin3

does i do somthing wrong or i need to rewrite st_find_extend whitout " for
tablename ?

thanks for you answers

T.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130703/fd5c81e2/attachment.html>


More information about the postgis-users mailing list