Get information about columns in a PostgreSQL table.
dbTableInfo(conn, name, allinfo = FALSE)
data frame
A connection object to a PostgreSQL database.
A character string specifying a PostgreSQL schema (if necessary), and table or view name (e.g., name = c("schema", "table")).
name = c("schema", "table")
Logical, Get all information on table? Default is column names, types, nullable, and maximum length of character columns.
David Bucklin david.bucklin@gmail.com
if (FALSE) { dbTableInfo(conn, c("schema", "table")) }
Run the code above in your browser using DataCamp Workspace