[postgis-users] sql command to see layers

[Stephen Woodbridge]

You might try   "select * from geometry_columns;"

-Steve W

Jürgen Mischker wrote:
> I am looking for a sql command that shows only the (geog.) layers in a postgis database.
> 
> also: a php class doing the same thing would be a big help. I found a postgis php class @ http://phpclasses.byting.at/browse/package/2039.html, but this particular function is missing.
> 
> Cheers for help
> juergen
> 
> DI Jürgen Mischker
> Insitut f. Vermessung, Fernerkundung und Landinformation,
> Universität für Bodenkultur, BOKU, Wien
> Institute of Surveying, Remote Sensing and Land Information.
> University of Natural Resources and Applied Life Science, Vienna.
> Tel.: +43 1 47654-5132
> Fax.: +43 1 47654-5142
> email: jmischker at boku.ac.at
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>