<P>
Hi All!<BR>
<BR>
Anybody uses openmap as front end and postgis as back end.<BR>
<BR>
Pl. give me idea - how to connect openmap with postgis and display map?<BR>
<BR>
Thanks & regards,<BR>
Amrita<BR>
<BR>
<BR>
On Tue, 27 Nov 2007 Nicolas Ribot wrote :<BR>
> > Hello,<BR>
> ><BR>
> > I have a table which contains a column 'tablename'. In this column, the<BR>
> > names of my geo tables are stored.<BR>
> > I want do write a query which deletes all geo tables in my database which<BR>
> > names don't appear in the column 'tablename' of this admin table. Has<BR>
> > someone any idea?<BR>
> ><BR>
><BR>
>Hello<BR>
><BR>
>If your geo tables were created with addGeometryColumns, or if you<BR>
>have updated the geometry_columns metadata table, then you have the<BR>
>list of all geo tables in it.<BR>
> >From it, and from your custom table, you should be able to build the<BR>
>list of geo tables that are not in your custom table.<BR>
>I think a pl/pgsql function is the easiest way to do this: for each<BR>
>geo table stored in the geometry_columns that is not in your admin<BR>
>table, generate a "drop table..." statement.<BR>
><BR>
>If you do not use geometry_columns table (which is bad), you will have<BR>
>to look at the Postgresql system tables to list all the tables having<BR>
>a geometric column, then filtering out those registered in your admin<BR>
>table.<BR>
>(i do not remember the name of such tables, but PostgreSQL<BR>
>documentation may help)<BR>
><BR>
>HTH<BR>
>Nico<BR>
>_______________________________________________<BR>
>postgis-users mailing list<BR>
>postgis-users@postgis.refractions.net<BR>
>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>
</P>
<br><br>
<Table border=0 Width=644 Height=57 cellspacing=0 cellpadding=0 style='font-family:Verdana;font-size:11px;line-height:15px;'><TR><td><a href='http://adworks.rediff.com/cgi-bin/AdWorks/click.cgi/www.rediff.com/signature-home.htm/1050715198@Middle5/1846186_1839156/1845568/1?PARTNER=3&OAS_QUERY=null target=new '><img src =http://imadworks.rediff.com/cgi-bin/AdWorks/adimage.cgi/1846186_1839156/creative_1845568.gif alt='mobiles' border=0></a></td></TR></Table>