R Interface to a 'PostGIS' Database


[Up] [Top]

Documentation for package ‘rpostgis’ version 1.4.3

Help Pages

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.
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.
pgWriteRast Write raster to PostGIS database table.
print.pgi Inserts data into a PostgreSQL table.
rpostgis R interface to a PostGIS database.