I am using a table that has a geometry
type column called "wkt". Its definition in the table looks like this:
create table sometable (
...
wkt geometry not null,
...
);
I want to change it to make sure that any geometry inserted will have an SRID of 4326. As a result, I want to do something like this to the "wkt" column:
wkt geometry(POINT, 4326) not null
But, this specifies that the geometry for the column is a POINT and I want the column to take any geometry as specified in the current definition.
How can I ensure that an SRID is applied to the column? Would I have to add a constraint to the "wkt" column such as "enforce_srid_the_geom" (as I gathered from the post How to change the SRID of exisisting data in PostGIS?) OR could I use some other form of the geometry
type that I don't know about?