//show all tables from db select * from pg_tables; //show all tables from but psq tables select * from pg_catalog.pg_tables where schemaname != 'information_schema' and schemaname != 'pg_catalog'; psql -U registrator -d registrator UPDATE regschema_shadow.registrator SET is_local = true WHERE id = id