I created a spatial table from a query. Now, I notice in geometry_columns, the following entry for the table:
f_table_catalog | f_table_schema | f_table_name | f_geometry_column | coord_dimension | srid | type my_db | public | my_table | geom | 2 | 0 | GEOMETRY
I want the srid to be 4326 (this is the srid of the original table) and the type to be Linestring (currently Geometry). Running the following,
SELECT Populate_Geometry_Columns('public.my_table'::regclass, false);
updated the srid in geometry_columns to 4326. However the type is still Geometry. How can I make sure that the geom column in my_table is properly recognized in the geometry_columns and its type is Linestring?