Tables list

Table 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 public postgres 0 18024 2 200 0 0 On Off 4 0 3 0 0 0 Off On Off Off 1475 16 kB
address public postgres 0 18076 7 603 0 0 On Off 8 0 9 0 0 0 Off On Off Off 1501 56 kB
category public postgres 0 18042 0 0 0 0 On Off 3 0 3 0 0 0 Off On Off Off 1487 8192 bytes
city public postgres 0 18083 4 600 0 0 On Off 4 0 5 0 0 0 Off On Off Off 1505 32 kB
country public postgres 0 18090 1 109 0 0 On Off 3 0 3 0 0 0 Off On Off Off 1509 8192 bytes
customer public postgres 0 18097 8 599 0 0 On Off 10 0 21 0 0 0 Off On Off Off 1513 64 kB
film public postgres 0 18049 55 1000 18058 0 On Off 14 0 12 0 0 0 Off On Off Off 1491 440 kB
film_actor public postgres 0 18061 27 5462 0 0 On Off 3 0 5 0 0 0 Off On Off Off 1493 216 kB
film_category public postgres 0 18065 5 1000 0 0 On Off 3 0 5 0 0 0 Off On Off Off 1495 40 kB
inventory public postgres 0 18116 25 4581 0 0 On Off 4 0 7 0 0 0 Off On Off Off 1521 200 kB
language public postgres 0 18123 0 0 0 0 On Off 3 0 5 0 0 0 Off On Off Off 1525 8192 bytes
payment public postgres 0 18135 0 0 0 0 On Off 6 0 6 0 0 0 Off On On On 1531 0 bytes
payment_p2007_01 public postgres 0 18139 9 1157 0 0 On Off 6 1 6 0 0 0 Off Off Off Off 1533 72 kB
payment_p2007_02 public postgres 0 18144 17 2312 0 0 On Off 6 1 6 0 0 0 Off Off Off Off 1535 136 kB
payment_p2007_03 public postgres 0 18149 42 5644 0 0 On Off 6 1 6 0 0 0 Off Off Off Off 1537 336 kB
payment_p2007_04 public postgres 0 18154 50 6754 0 0 On Off 6 1 6 0 0 0 Off Off Off Off 1539 400 kB
payment_p2007_05 public postgres 0 18159 2 182 0 0 On Off 6 1 6 0 0 0 Off Off Off Off 1541 16 kB
payment_p2007_06 public postgres 0 18164 0 0 0 0 On Off 6 1 6 0 0 0 Off Off Off Off 1543 0 bytes
pg_aggregate pg_catalog guillaume 0 2600 1 117 0 0 On Off 6 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 8192 bytes
pg_am pg_catalog guillaume 0 2601 1 4 0 0 On Off 24 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_amop pg_catalog guillaume 0 2602 3 347 0 0 On Off 7 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 24 kB
pg_amproc pg_catalog guillaume 0 2603 2 243 0 0 On Off 5 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 16 kB
pg_attrdef pg_catalog guillaume 0 2604 0 0 2830 0 On Off 4 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 16 kB
pg_attribute pg_catalog guillaume 0 1249 39 2331 0 0 On Off 17 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 312 kB
pg_auth_members pg_catalog guillaume 0 1261 pg_global 0 0 0 0 On On 4 0 1 0 0 0 Off Off Off Off 379 {=r/guillaume} 0 bytes
pg_authid pg_catalog guillaume 0 1260 pg_global 1 1 2842 0 On On 11 0 1 0 0 0 On Off Off Off 379 {guillaume=arwdxt/guillaume} 8192 bytes
pg_autovacuum pg_catalog guillaume 0 1248 0 0 0 0 On Off 10 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 0 bytes
pg_cast pg_catalog guillaume 0 2605 2 191 0 0 On Off 4 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 16 kB
pg_class pg_catalog guillaume 0 1259 8 315 0 0 On Off 27 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 64 kB
pg_constraint pg_catalog guillaume 0 2606 3 63 2832 0 On Off 18 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 24 kB
pg_conversion pg_catalog guillaume 0 2607 2 130 0 0 On Off 7 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 16 kB
pg_database pg_catalog guillaume 0 1262 pg_global 1 2 2844 0 On On 11 0 1 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_depend pg_catalog guillaume 0 2608 42 6030 0 0 On Off 7 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 336 kB
pg_description pg_catalog guillaume 0 2609 16 1988 2834 0 On Off 4 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 128 kB
pg_enum pg_catalog guillaume 0 3501 0 0 0 0 On Off 2 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_index pg_catalog guillaume 0 2610 2 90 0 0 On Off 14 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 24 kB
pg_inherits pg_catalog guillaume 0 2611 0 0 0 0 On Off 3 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 8192 bytes
pg_language pg_catalog guillaume 0 2612 1 3 0 0 On Off 7 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_largeobject pg_catalog guillaume 0 2613 0 0 0 0 On Off 3 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 0 bytes
pg_listener pg_catalog guillaume 0 2614 0 0 0 0 Off Off 3 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 0 bytes
pg_namespace pg_catalog guillaume 0 2615 1 6 0 0 On Off 3 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_opclass pg_catalog guillaume 0 2616 2 112 0 0 On Off 8 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 16 kB
pg_operator pg_catalog guillaume 0 2617 13 702 0 0 On Off 14 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 104 kB
pg_opfamily pg_catalog guillaume 0 2753 1 69 0 0 On Off 4 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_pltemplate pg_catalog guillaume 0 1136 pg_global 1 6 0 0 On On 7 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 8192 bytes
pg_proc pg_catalog guillaume 0 1255 50 2143 2836 0 On Off 21 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 408 kB
pg_rewrite pg_catalog guillaume 0 2618 8 75 2838 0 On Off 8 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 80 kB
pg_shdepend pg_catalog guillaume 0 1214 pg_global 2 199 0 0 On On 6 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 16 kB
pg_shdescription pg_catalog guillaume 0 2396 pg_global 1 1 2846 0 On On 3 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 8192 bytes
pg_statistic pg_catalog guillaume 0 2619 16 434 2840 0 On Off 21 0 0 0 0 0 Off Off Off Off 379 {guillaume=arwdxt/guillaume} 128 kB
pg_tablespace pg_catalog guillaume 0 1213 pg_global 1 2 0 0 On On 4 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_trigger pg_catalog guillaume 0 2620 7 178 0 0 On Off 14 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 56 kB
pg_ts_config pg_catalog guillaume 0 3602 1 16 0 0 On Off 4 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_ts_config_map pg_catalog guillaume 0 3603 2 304 0 0 On Off 4 0 0 0 0 0 Off Off Off Off 379 {=r/guillaume} 16 kB
pg_ts_dict pg_catalog guillaume 0 3600 1 16 0 0 On Off 5 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_ts_parser pg_catalog guillaume 0 3601 1 1 0 0 On Off 7 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_ts_template pg_catalog guillaume 0 3764 1 5 0 0 On Off 4 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 8192 bytes
pg_type pg_catalog guillaume 0 1247 8 343 0 0 On Off 26 0 0 0 0 0 On Off Off Off 379 {=r/guillaume} 72 kB
rental public postgres 0 18171 134 16044 0 0 On Off 7 0 21 0 0 0 Off On Off Off 1547 1072 kB
staff public postgres 0 18183 0 0 18189 0 On Off 11 0 23 0 0 0 Off On Off Off 1553 8192 bytes
store public postgres 0 18194 0 0 0 0 On Off 4 0 11 0 0 0 Off On Off Off 1557 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 = 'r' AND relowner = pg_roles.oid AND relnamespace = pg_namespace.oid AND pg_table_is_visible(pg_class.oid) ORDER BY relname