R Interface to a 'PostGIS' Database


[Up] [Top]

Documentation for package ‘rpostgis’ version 1.5.1

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