Postgres SQL Command

Jump to bottom

Zhamri Che Ani edited this page May 2, 2021 · 1 revision

SELECT datname FROM pg_database;

SELECT * FROM pg_catalog.pg_tables;
select * from auth_user;

SELECT *
FROM pg_catalog.pg_tables
WHERE schemaname != 'pg_catalog' AND
    schemaname != 'information_schema';