pgPostGIS()
Check and create PostGIS extension.
pgListGeom() pgListRast()
pgListGeom()
pgListRast()
List geometries/rasters
pgSRID()
Find (or create) PostGIS SRID based on CRS object.
pgInsert() print(<pgi>)
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.
pgGetBoundary()
Retrieve bounding envelope of geometries or rasters.
pgMakePts() pgMakeStp()
pgMakePts()
pgMakeStp()
Add a POINT or LINESTRING geometry field.
dbWriteDataFrame() dbReadDataFrame()
dbWriteDataFrame()
dbReadDataFrame()
Write/read in data frame mode to/from database table.
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.