postgis

Adds geographic object support and spatial indexing to PostgreSQL

brewmacoslinux

Try with needOr install directly

About

Adds support for geographic objects to PostgreSQL

pgsql2shpshp2pgsqlraster2pgsql

Convert ESRI shapefile to SQL for PostgreSQL import$ shp2pgsql -I -M roads.shp roads_table | psql -d mydb

Export PostgreSQL table with geometry to shapefile$ pgsql2shp -f exported_roads mydb roads_table

Import raster data into PostGIS raster table$ raster2pgsql -I -M dem.tif public.dem | psql -d mydb