[postgis-users] Convert from Lat/Long point to postGIS geometry

[Marco Lechner - FOSSGIS e.V.]

Hi,

try this http://www.postgis.org/docs/ST_GeomFromText.html

Marco

Am 03.02.2015 um 05:11 schrieb KhunSanAung:
> Hi All,
>
> I have one table (Town info) in postgres without Geometry field.
> I have Latitude and Longitude information for those points data
> separately (collecting & filling).
>
> I created the postGIS extension and add the Geometry field in the
> above postgres table.
> Now, I'd like to add the location information into the postGIS
> geometry field so that I can immediately view those points on the map. 
>
> How can I convert the Latitude/Longitude value into postGIS geometry
> value?
>
> Thank you very much in advance.
>
> -- 
> Have a nice day!
> --
>
> *Mr. Khun San Aung*
>
> ____
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150205/1c718ccc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x6A30F373.asc
Type: application/pgp-keys
Size: 2454 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150205/1c718ccc/attachment.key>