Trending
Monday, June 24, 2013

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



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


2 comments:

Item Reviewed: How to add Geometry data type column to a table in Postgres? - ST_GeomFromText() Rating: 5 Reviewed By: Ravi Kumar