List geometries/rasters

List all geometry/(geography) or raster columns available in a PostGIS database.

Usage

pgListGeom(conn, geog = TRUE)

pgListRast(conn)

Arguments

conn

A PostgreSQL database connection.

geog

Logical. For pgListGeom, whether to include PostGIS geography-type columns stored in the database

Value

If exec = TRUE, a data frame with schema, table, geometry/(geography) or raster (for pgListRast) column, and geometry/(geography) type.

Author

David Bucklin david.bucklin@gmail.com

Examples

if (FALSE) { # \dontrun{
pgListGeom(conn)

pgListRast(conn)
} # }