Top Ad unit 728 × 90

New Articles

random

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


How to add Geometry data type column to a table in Postgres? - ST_GeomFromText() Reviewed by Ravi Kumar on 4:44 PM Rating: 5

2 comments:

All Rights Reserved by Etech Pulse - "Coding Is Today's Language Of Creativity" © 2014 - 2015
Powered By Blogger

Contact Form

Name

Email *

Message *

Powered by Blogger.