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() print(<pgi>)

Inserts data into a PostgreSQL table.

pgGetGeom()

Load a PostGIS geometry from a PostgreSQL table/view/query into R.

pgWriteRast()

Write raster to PostGIS database table.

pgGetRast()

Load raster from PostGIS database.

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.