【Postgres】srid查询及更新

text UpdateGeometrySRID(varchar table_name, varchar column_name, integer srid);
 
text UpdateGeometrySRID(varchar schema_name, varchar table_name, varchar column_name, integer srid);
 
text UpdateGeometrySRID(varchar catalog_name, varchar schema_name, varchar table_name, varchar column_name, integer srid);

select UpdateGeometrySRID(‘tablename‘, ‘geom‘, 4326);

select st_srid(geom) from table;