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. |