(cross-posted from SO https://stackoverflow.com/q/55869582/2802810)
I've accidentally dropped geometry_columns and geography_columns tables from an existing PostgreSQL PostGIS database schema - let's call it mydb.myschema.
This post outlines how to restore using CREATE TABLE ... with .sql from PostGIS install (I am on a shared server and am having to get my devops to look for them because of permissions).
I wanted to check if this will work. Also, do these two tables (geometry_columns and geography_columns) contain data relating to the geometries held in existing tables in mydb.myschema. Or do geometry_columns and geography_columns hold reference information for spatial operations?
Any advice from anyone who has gone through this before?
Running PostGIS 2.5.2 on PG 11.x.
[NOTE: No backup available as snapshots weren't set up beforehand...]