dbAddKey | Add key. |
dbAsDate | Converts to timestamp. |
dbColumn | Add or remove a column. |
dbComment | Comment table/view/schema. |
dbDrop | Drop table/view/schema. |
dbIndex | Create an index. |
dbReadDataFrame | Write/read in data frame mode to/from database table. |
dbReadDF | Write/read in data frame mode to/from database table. |
dbSchema | Check and create schema. |
dbTableInfo | Get information about table columns. |
dbVacuum | Vacuum. |
dbWriteDataFrame | Write/read in data frame mode to/from database table. |
dbWriteDF | Write/read in data frame mode to/from database table. |
pgGetBoundary | Retrieve bounding envelope of geometries or rasters. |
pgGetGeom | Load a PostGIS geometry from a PostgreSQL table/view/query into R. |
pgGetRast | Load raster from PostGIS database into R. |
pgInsert | Inserts data into a PostgreSQL table. |
pgListGeom | List geometries/rasters |
pgListRast | List geometries/rasters |
pgMakePts | Add a POINT or LINESTRING geometry field. |
pgMakeStp | Add a POINT or LINESTRING geometry field. |
pgPostGIS | Check and create PostGIS extension. |
pgSRID | Find (or create) PostGIS SRID based on CRS object. |
pgWriteGeom | Inserts data into a PostgreSQL table. |
pgWriteRast | Write raster to PostGIS database table. |
print.pgi | Inserts data into a PostgreSQL table. |