Solved is trouble with lower case when i generate the table name
On Wed, Jul 3, 2013 at 4:53 PM, Tonton <[email protected]> wrote: > 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. >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
