Function reference • 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()`	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.

Reference