Package index • rpostgis

PostGIS management

pgPostGIS(): Check and create PostGIS extension.

pgListGeom() pgListRast(): List geometries/rasters

pgSRID(): Find (or create) PostGIS SRID based on CRS object.

Spatial data transfer

pgInsert() obsoleta: Inserts data into a PostgreSQL table.

pgGetGeom(): Load a PostGIS geometry from a PostgreSQL table/view/query into R.

pgWriteGeom() print(<pgi>): Inserts data into a PostgreSQL table.

pgWriteRast(): Write raster to PostGIS database table.

pgGetRast(): Load raster from PostGIS database into R.

Other spatial functions

pgGetBoundary(): Retrieve bounding envelope of geometries or rasters.

pgMakePts() pgMakeStp(): Add a POINT or LINESTRING geometry field.

Storing R data.frame’s in PostgreSQL

dbWriteDataFrame() dbReadDataFrame(): Write/read in data frame mode to/from database table.

SQL wrappers for database management

dbSchema(): Check and create schema.

dbComment(): Comment table/view/schema.

dbColumn(): Add or remove a column.

dbAddKey(): Add key.

dbAsDate(): Converts to timestamp.

dbIndex(): Create an index.

dbVacuum(): Vacuum.

dbDrop(): Drop table/view/schema.

dbTableInfo(): Get information about table columns.