My database contains both Spatial and Non-Spatial tables, but I want to retrieve only Spatial table from the query.
Any suggestions to select only Spatial tables. 'the_geom' is the geometry column in the spatial table.
Otherwise, is it possible to select tables from its column name.
I tried with this code
select relname from pg_stat_user_tables WHERE schemaname='public' ; but from this we get all table names.