dbListTables doen't list views. dbListViews?

[Domenico Giusti]

Hi all,

I wonder how to list views, if possible. Does it exist a dbListViews?

Thanks a lot,

[Neil Tiffin]

dbListViews does not exist, try the following SQL

select schema name, viewname from pg_catalog.pg_views;

or

select schemaname, viewname from pg_catalog.pg_views
where schemaname NOT IN ('pg_catalog', 'information_schema')
order by schema name, viewname;

Neil

[Domenico Giusti]

Dear Neil,

it works, thank you!

## Submits a statement
rs <- dbSendQuery(con, "SELECT viewname from pg_catalog.pg_views where viewowner = 'user'")
## Fetch all elements from the result set
fetch(rs,n=-1)

Best,