| Sequence 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_actor_id_seq | public | postgres | 0 | 18022 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| address_address_id_seq | public | postgres | 0 | 18074 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| category_category_id_seq | public | postgres | 0 | 18040 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| city_city_id_seq | public | postgres | 0 | 18081 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| country_country_id_seq | public | postgres | 0 | 18088 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| customer_customer_id_seq | public | postgres | 0 | 18095 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| film_film_id_seq | public | postgres | 0 | 18047 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| inventory_inventory_id_seq | public | postgres | 0 | 18114 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| language_language_id_seq | public | postgres | 0 | 18121 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| payment_payment_id_seq | public | postgres | 0 | 18133 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| rental_rental_id_seq | public | postgres | 0 | 18169 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| staff_staff_id_seq | public | postgres | 0 | 18181 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 bytes | ||||
| store_store_id_seq | public | postgres | 0 | 18192 | 1 | 1 | 0 | 0 | f | f | 9 | 0 | 0 | 0 | 0 | 0 | f | f | f | |
0 | 8192 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 = 'S' AND relowner = pg_roles.oid AND relnamespace = pg_namespace.oid AND pg_table_is_visible(pg_class.oid) ORDER BY relname