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

Description Usage Arguments Value Author(s) See Also Examples

Get information about tables in a database

list_tables(only.names = TRUE)

describe_table(tablename, schemaname = NULL)

list_schema(only.names = TRUE)

list_databases(only.names = TRUE)

`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: 
createdb("rpgtesting")
connect("rpgtesting")
begin()
 
# write data frame contents
data(mtcars)
write_table(mtcars)
 
# get some information
list_tables()
describe_table("mtcars")
list_schema()
list_databases()

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