AddGeometryColumn to a postgres table - PostGIS

In this post I will explain how to add a geometry data type column. Here I have data in .csv file without a Geometry column shown below.

How to add Geometry data type column to a table in Postgres? - ST_GeomFromText()

Now I create a table and copy all the data to postgres table using following command.

Now we can update geometry column with respect to latitude & longitude using the below query.


alter table modify column,  column table,geometry column,update,create,geospatial data, postgresql

Post a Comment