rpostgis (version 1.4.3)

dbTableInfo: Get information about table columns.

Description

Get information about columns in a PostgreSQL table.

Usage

dbTableInfo(conn, name, allinfo = FALSE)

Value

data frame

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.

Author

David Bucklin david.bucklin@gmail.com

Examples

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

Run the code above in your browser using DataCamp Workspace