Re: [Geoserver-users] PostgreSQL and PostGIS

[Russ H. <ru...@ru...>]

Have you installed the ostGIS extension?

CREATE EXTENSION postgis;

If so you can add a Geometry column with;

https://postgis.net/docs/AddGeometryColumn.html

Set the SRID to what your data is.

Then you ST_MakePoint (If it is point data) to update the new column using the data from other fields in the row.

https://postgis.net/docs/ST_MakePoint.html

Something like UPDATE tablename set the_geom=ST_makePoint(X, Y)


> 
> Jody,
>  
> If I have a PostgreSQL database that contains spatial coordinates, do you know how I convert that database into PostGIS format so I can publish it on GeoServer?
>  
> Jim Rogers
> _______________________________________________
> Geoserver-users mailing list
> 
> Please make sure you read the following two resources before posting to this list:
> - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html
> 
> If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
> 
> 
> Geo...@li... <mailto:Geo...@li...>
> https://lists.sourceforge.net/lists/listinfo/geoserver-users