table-info: PostgreSQL database information
In rpg: Easy Interface to Advanced PostgreSQL Features

Description Usage Arguments Value Author(s) See Also Examples

Get information about tables in a database

1
2
3

list_tables(only.names = TRUE)

describe_table(tablename, schemaname = NULL)

`only.names`	if true, just list the table names
`tablename`	the name of a PostgreSQL table
`schemaname`	if not null, look only in this schema

list_tables: a vector of table names or a data frame

describe_table: a data frame with column information

Timothy H. Keitt

psql

## Not run: 
system("createdb rpgtesting")
connect("rpgtesting")
begin()

# write data frame contents
data(mtcars)
write_table(mtcars)

# get some information
list_tables()
describe_table("mtcars")

#cleanup
rollback()
disconnect()
system("dropdb rpgtesting")
## End(Not run)