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

AddGeometryColumn to a postgres table - PostGIS

In my previous articles I explained How to convert latitude and longitude to Geometry Point in Postgres?, Get Latitude and Longitude from Geometry Point in PostGres?, How to convert latitude and longitude to Geometry Point in Postgres?, How to import data from .CSV in PostGres table in a simple way?

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.

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: