List all geometry/(geography) or raster columns available in a PostGIS database.
pgListGeom(conn, geog = TRUE)pgListRast(conn)
pgListRast(conn)
If exec = TRUE, a data frame with schema, table, geometry/(geography) or raster (for pgListRast) column, and geometry/(geography) type.
exec = TRUE
A PostgreSQL database connection.
Logical. For pgListGeom, whether to include PostGIS geography-type columns stored in the database
David Bucklin david.bucklin@gmail.com
if (FALSE) { pgListGeom(conn) pgListRast(conn) }
Run the code above in your browser using DataLab