PostGIS table discovery (list tables/views with geometry)

[mikemcdougall]

Summary

Implement table discovery to list all PostGIS tables and views that contain geometry columns.

Tasks

• Query geometry_columns view for spatial tables
• Query geography_columns view for geography tables
• Include table name, schema, geometry column, SRID, geometry type
• Support filtering by schema
• Show row count estimate
• Detect primary key column

API

GET /api/admin/connections/{id}/tables
Response: [
  {
    "schema": "public",
    "table": "parcels",
    "geometryColumn": "geom",
    "geometryType": "MULTIPOLYGON",
    "srid": 4326,
    "estimatedRows": 50000
  }
]

Acceptance Criteria

• Lists all spatial tables in connected database
• Shows geometry type and SRID for each
• Excludes system tables
• Works with both geometry and geography columns