Get information about table columns.

Get information about columns in a PostgreSQL table.

dbTableInfo(conn, name, allinfo = FALSE)

Arguments

conn

A connection object to a PostgreSQL database.

name

A character string specifying a PostgreSQL schema (if necessary), and table or view name (e.g., name = c("schema", "table")).

allinfo

Logical, Get all information on table? Default is column names, types, nullable, and maximum length of character columns.

Value

data frame

Author

David Bucklin david.bucklin@gmail.com

Examples

if (FALSE) {
dbTableInfo(conn, c("schema", "table"))
}