[postgis-users] st_find_extent postgresql-9.1-postgis

[Tonton]

Solved is trouble with lower case when i generate the table name



On Wed, Jul 3, 2013 at 4:53 PM, Tonton <to.tonton at gmail.com> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130703/86ac1e28/attachment.html>