PostgreSQL

Отличия от других СУБД §

PostgreSQL vs. MySQL: A 360-degree Comparison [Syntax, Performance, Scalability and Features] (enterprisedb.com) SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems | DigitalOcean

List all constraints of a table in PostgreSQL §

SELECT con.*
    FROM pg_catalog.pg_constraint con
        INNER JOIN pg_catalog.pg_class rel ON rel.oid = con.conrelid
        INNER JOIN pg_catalog.pg_namespace nsp ON nsp.oid = connamespace
        WHERE nsp.nspname = '{schema name}'
             AND rel.relname = '{table name}';

---

📂 SQL | Последнее изменение: 15.09.2024 13:37