Сервисные таблицы

information_schema

Список таблиц

select
    table_name
from
    information_schema.tables
where
    table_schema = 'public'
order by table_name;
table_name
----------
sessions
books
authors