[postgis-users] Anybody uses openmap

Amrita p amritaprasad1 at rediffmail.com
Tue Nov 27 02:17:03 PST 2007


Hi All!

Anybody uses openmap as front end and postgis as back end.

Pl. give me idea - how to connect openmap with postgis and display map?

Thanks & regards,
Amrita


On Tue, 27 Nov 2007 Nicolas Ribot wrote :
> > Hello,
> >
> > I have a table which contains a column 'tablename'. In this column, the
> > names of my geo tables are stored.
> > I want do write a query which deletes all geo tables in my database which
> > names don't appear in the column 'tablename' of this admin table. Has
> > someone any idea?
> >
>
>Hello
>
>If your geo tables were created with addGeometryColumns, or if you
>have updated the geometry_columns metadata table, then you have the
>list of all geo tables in it.
> >From it, and from your custom table, you should be able to build the
>list of geo tables that are not in your custom table.
>I think a pl/pgsql function is the easiest way to do this: for each
>geo table stored in the geometry_columns that is not in your admin
>table, generate a "drop table..." statement.
>
>If you do not use geometry_columns table (which is bad), you will have
>to look at the Postgresql system tables to list all the tables having
>a geometric column, then filtering out those registered in your admin
>table.
>(i do not remember the name of such tables, but PostgreSQL
>documentation may help)
>
>HTH
>Nico
>_______________________________________________
>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/20071127/3cf3f6ed/attachment.html>


More information about the postgis-users mailing list