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 > > > Geoserver-users@lists.sourceforge.net > <mailto:Geoserver-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
_______________________________________________ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users