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.


Output:

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


Post a Comment

 
Top