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

[jcradock at me3.com]

Armin,

If you're adding the columns via AddGeometryColumn they should be in the
geometry_columns table. Try

\d geometry_columns

to see the structure of this table.

Jim

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-----
James Cradock, jcradock at me3.com