baking=> \d pg_class
                     Table "pg_catalog.pg_class"
       Column        |     Type     | Collation | Nullable | Default
---------------------+--------------+-----------+----------+---------
 oid                 | oid          |           | not null |
 relname             | name         |           | not null |
 relnamespace        | oid          |           | not null |
 reltype             | oid          |           | not null |
 reloftype           | oid          |           | not null |
 relowner            | oid          |           | not null |
 relam               | oid          |           | not null |
 relfilenode         | oid          |           | not null |
 reltablespace       | oid          |           | not null |
 relpages            | integer      |           | not null |
 reltuples           | real         |           | not null |
 relallvisible       | integer      |           | not null |
 reltoastrelid       | oid          |           | not null |
 relhasindex         | boolean      |           | not null |
 relisshared         | boolean      |           | not null |
 relpersistence      | "char"       |           | not null |
 relkind             | "char"       |           | not null |
 relnatts            | smallint     |           | not null |
 relchecks           | smallint     |           | not null |
 relhasrules         | boolean      |           | not null |
 relhastriggers      | boolean      |           | not null |
 relhassubclass      | boolean      |           | not null |
 relrowsecurity      | boolean      |           | not null |
 relforcerowsecurity | boolean      |           | not null |
 relispopulated      | boolean      |           | not null |
 relreplident        | "char"       |           | not null |
 relispartition      | boolean      |           | not null |
 relrewrite          | oid          |           | not null |
 relfrozenxid        | xid          |           | not null |
 relminmxid          | xid          |           | not null |
 relacl              | aclitem[]    |           |          |
 reloptions          | text[]       | C         |          |
 relpartbound        | pg_node_tree | C         |          |
Indexes:
    "pg_class_oid_index" UNIQUE, btree (oid)
    "pg_class_relname_nsp_index" UNIQUE, btree (relname, relnamespace)
    "pg_class_tblspc_relfilenode_index" btree (reltablespace, relfilenode)


baking=> SELECT * FROM pg_user ;
 usename  | usesysid | usecreatedb | usesuper | userepl | usebypassrls |  passwd  | valuntil | useconfig
----------+----------+-------------+----------+---------+--------------+----------+----------+-----------
 postgres |       10 | t           | t        | t       | t            | ******** |          |
 kkuzmin  |    16568 | t           | f        | f       | f            | ******** |          |
(2 rows)


baking=> SELECT relname, relkind, relpages
baking-> FROM pg_class pc, pg_user pu
baking-> WHERE pc.relowner = pu.usesysid and pu.usename = user
baking-> ORDER BY relpages desc;
      relname      | relkind | relpages
-------------------+---------+----------
 technicals_pkey   | i       |        2
 signatures_pkey   | i       |        2
 showstoppers_pkey | i       |        2
 bakers_pkey       | i       |        1
 episodes_pkey     | i       |        1
 signatures        | r       |        1
 showstoppers      | r       |        1
 technicals        | r       |        1
 results_pkey      | i       |        1
 favorites_pkey    | i       |        1
 bakers            | r       |        0
 favorites         | r       |        0
 episodes          | r       |        0
 results           | r       |        0
(14 rows)


baking=> \c streaming
You are now connected to database "streaming" as user "kkuzmin".
streaming=> SELECT relname, relkind, relpages
streaming-> FROM pg_class pc, pg_user pu
streaming-> WHERE pc.relowner = pu.usesysid and pu.usename = user
streaming-> ORDER BY relpages desc;
        relname        | relkind | relpages
-----------------------+---------+----------
 series                | r       |     1149
 moviesonplatform      | r       |      379
 onplatform_pkey       | i       |      261
 movies                | r       |      226
 moviesgenres          | r       |      211
 moviegenres_pkey      | i       |      152
 seriesgenres          | r       |      133
 moviescountry         | r       |      125
 moviesdirectors       | r       |      112
 movieslanguages       | r       |      111
 moviescast            | r       |      107
 seriesgenre_pkey      | i       |       97
 moviecountries_pkey   | i       |       96
 moviedirectors_pkey   | i       |       87
 moviescast_pkey       | i       |       83
 movielanguages_pkey   | i       |       81
 seriescast            | r       |       68
 seriesonplatform      | r       |       62
 seriescast_pkey       | i       |       54
 movies1_pkey          | i       |       48
 onplatformseries_pkey | i       |       46
 series_pkey           | i       |       36
 seriescategory        | r       |       21
 seriescategory_pkey   | i       |       18
 seriescountry         | r       |        9
 seriescountry_pkey    | i       |        9
 seriesdirectors_pkey  | i       |        2
 pg_toast_19288_index  | i       |        1
 pg_toast_19312_index  | i       |        1
 seriesdirectors       | r       |        1
 pg_toast_19288        | t       |        0
 pg_toast_19312        | t       |        0
(32 rows)


streaming=> SEELCT COUNT(*) series;
ERROR:  syntax error at or near "SEELCT"
LINE 1: SEELCT COUNT(*) series;
        ^
streaming=> SELECT COUNT(*) series;
 series
--------
      1
(1 row)


streaming=> SELECT COUNT(*) FROM series;
 count
-------
 12353
(1 row)


streaming=> SELECT COUNT(*) FROM movies;
 count
-------
 16744
(1 row)


streaming=> \d series
                          Table "public.series"
     Column     |          Type          | Collation | Nullable | Default
----------------+------------------------+-----------+----------+---------
 seriesid       | integer                |           | not null |
 title          | character varying(400) |           |          |
 yearreleased   | integer                |           |          |
 contentrating  | character varying(40)  |           |          |
 imdbrating     | double precision       |           |          |
 rottentomatoes | integer                |           |          |
 description    | text                   |           |          |
 seasons        | integer                |           |          |
 date_added     | date                   |           |          |
Indexes:
    "series_pkey" PRIMARY KEY, btree (seriesid)
Referenced by:
    TABLE "seriesonplatform" CONSTRAINT "onplatformseries_seriesid_fkey" FOREIGN KEY (seriesid) REFERENCES series(seriesid)
    TABLE "seriescast" CONSTRAINT "seriescast_seriesid_fkey" FOREIGN KEY (seriesid) REFERENCES series(seriesid)
    TABLE "seriescategory" CONSTRAINT "seriescategory_seriesid_fkey" FOREIGN KEY (seriesid) REFERENCES series(seriesid)
    TABLE "seriescountry" CONSTRAINT "seriescountry_seriesid_fkey" FOREIGN KEY (seriesid) REFERENCES series(seriesid)
    TABLE "seriesdirectors" CONSTRAINT "seriesdirectors_seriesid_fkey" FOREIGN KEY (seriesid) REFERENCES series(seriesid)
    TABLE "seriesgenres" CONSTRAINT "seriesgenre_seriesid_fkey" FOREIGN KEY (seriesid) REFERENCES series(seriesid)


streaming=>