Views list

View name Schema name Table Owner relam relfilenode Tablespace name Pages # Tuples # OID Toast Table OID Toast Index Has index? Is shared? Kind natts Checks Triggers Unique Keys Foreign Keys Refs Has OID? Has Primary Key? Has Rules? Has subclass? Frozen XID ACL Options Size
actor_info public postgres 0 18069 0 0 0 0 Off Off 4 0 0 0 0 0 Off Off On Off 0 0 bytes
customer_list public postgres 0 18104 0 0 0 0 Off Off 9 0 0 0 0 0 Off Off On Off 0 0 bytes
film_list public postgres 0 18109 0 0 0 0 Off Off 8 0 0 0 0 0 Off Off On Off 0 0 bytes
nicer_but_slower_film_list public postgres 0 18128 0 0 0 0 Off Off 8 0 0 0 0 0 Off Off On Off 0 0 bytes
pg_buffercache public guillaume 0 18498 0 0 0 0 Off Off 7 0 0 0 0 0 Off Off On Off 0 {guillaume=arwdxt/guillaume} 0 bytes
pg_cursors pg_catalog guillaume 0 10972 0 0 0 0 Off Off 6 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_freespacemap_pages public guillaume 0 18508 0 0 0 0 Off Off 5 0 0 0 0 0 Off Off On Off 0 {guillaume=arwdxt/guillaume} 0 bytes
pg_freespacemap_relations public guillaume 0 18512 0 0 0 0 Off Off 7 0 0 0 0 0 Off Off On Off 0 {guillaume=arwdxt/guillaume} 0 bytes
pg_group pg_catalog guillaume 0 10944 0 0 0 0 Off Off 3 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_indexes pg_catalog guillaume 0 10961 0 0 0 0 Off Off 5 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_locks pg_catalog guillaume 0 10969 0 0 0 0 Off Off 14 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_prepared_statements pg_catalog guillaume 0 10978 0 0 0 0 Off Off 5 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_prepared_xacts pg_catalog guillaume 0 10975 0 0 0 0 Off Off 5 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_roles pg_catalog guillaume 0 10938 0 0 0 0 Off Off 12 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_rules pg_catalog guillaume 0 10950 0 0 0 0 Off Off 4 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_settings pg_catalog guillaume 0 10981 0 0 0 0 Off Off 11 0 0 0 0 0 Off Off On Off 0 {guillaume=arwdxt/guillaume,=rw/guillaume} 0 bytes
pg_shadow pg_catalog guillaume 0 10941 0 0 0 0 Off Off 8 0 0 0 0 0 Off Off On Off 0 {guillaume=arwdxt/guillaume} 0 bytes
pg_stat_activity pg_catalog guillaume 0 11041 0 0 0 0 Off Off 12 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_stat_all_indexes pg_catalog guillaume 0 11012 0 0 0 0 Off Off 8 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_stat_all_tables pg_catalog guillaume 0 10992 0 0 0 0 Off Off 17 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_stat_bgwriter pg_catalog guillaume 0 11047 0 0 0 0 Off Off 7 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_stat_database pg_catalog guillaume 0 11044 0 0 0 0 Off Off 12 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_stat_sys_indexes pg_catalog guillaume 0 11016 0 0 0 0 Off Off 8 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_stat_sys_tables pg_catalog guillaume 0 10996 0 0 0 0 Off Off 17 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_stat_user_indexes pg_catalog guillaume 0 11019 0 0 0 0 Off Off 8 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_stat_user_tables pg_catalog guillaume 0 10999 0 0 0 0 Off Off 17 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_statio_all_indexes pg_catalog guillaume 0 11022 0 0 0 0 Off Off 7 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_statio_all_sequences pg_catalog guillaume 0 11032 0 0 0 0 Off Off 5 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_statio_all_tables pg_catalog guillaume 0 11002 0 0 0 0 Off Off 11 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_statio_sys_indexes pg_catalog guillaume 0 11026 0 0 0 0 Off Off 7 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_statio_sys_sequences pg_catalog guillaume 0 11035 0 0 0 0 Off Off 5 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_statio_sys_tables pg_catalog guillaume 0 11006 0 0 0 0 Off Off 11 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_statio_user_indexes pg_catalog guillaume 0 11029 0 0 0 0 Off Off 7 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_statio_user_sequences pg_catalog guillaume 0 11038 0 0 0 0 Off Off 5 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_statio_user_tables pg_catalog guillaume 0 11009 0 0 0 0 Off Off 11 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_stats pg_catalog guillaume 0 10965 0 0 0 0 Off Off 10 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_tables pg_catalog guillaume 0 10957 0 0 0 0 Off Off 7 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_timezone_abbrevs pg_catalog guillaume 0 10986 0 0 0 0 Off Off 3 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_timezone_names pg_catalog guillaume 0 10989 0 0 0 0 Off Off 4 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_user pg_catalog guillaume 0 10947 0 0 0 0 Off Off 8 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
pg_views pg_catalog guillaume 0 10954 0 0 0 0 Off Off 4 0 0 0 0 0 Off Off On Off 0 {=r/guillaume} 0 bytes
sales_by_film_category public postgres 0 18176 0 0 0 0 Off Off 2 0 0 0 0 0 Off Off On Off 0 0 bytes
sales_by_store public postgres 0 18199 0 0 0 0 Off Off 3 0 0 0 0 0 Off Off On Off 0 0 bytes
staff_list public postgres 0 18204 0 0 0 0 Off Off 8 0 0 0 0 0 Off Off On Off 0 0 bytes

SELECT relname, nspname AS schema, rolname AS owner, relam, relfilenode, (select spcname from pg_tablespace where oid=reltablespace) as tablespace, relpages, reltuples, reltoastrelid, reltoastidxid, relhasindex, relisshared, reltype, relnatts, relchecks, reltriggers, relukeys, relfkeys, relrefs, relhasoids, relhaspkey, relhasrules, relhassubclass, relfrozenxid, relacl, reloptions, pg_size_pretty(pg_relation_size(pg_class.oid)) AS size FROM pg_class, pg_roles, pg_namespace WHERE relkind = 'v' AND relowner = pg_roles.oid AND relnamespace = pg_namespace.oid AND pg_table_is_visible(pg_class.oid) ORDER BY relname