Get information about table columns.

Share:

Description

Get information about columns in a PostgreSQL table.

Usage

1
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 geometry (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(s)

David Bucklin dbucklin@ufl.edu

Examples

1
2
3
4
## Not run: 
dbTableInfo(conn, c("schema", "table"))

## End(Not run)