[postgis-users] SQL query to identify tables and views with geometry field

[Sean Gillies]

On Nov 25, 2005, at 12:28 PM, Armin Burger wrote:

> Hi everyone,
>
> is there a way to find all tables and views in a PostGIS-enabled  
> database that contain a geometry field, using just a SQL query?
>
> Armin

If your database is in proper shape

   select f_table_name from geometry_columns;

cheers,
Sean



---
Sean Gillies
sgillies at frii dot com
http://zcologia.com/news