List all constraints in postgres

How to see constraints 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>';

Source: dba.stackexchange.com

List all constraints in postgres

SELECT *
       FROM pg_catalog.pg_constraint con,
	   pg_catalog.pg_class rel,
	   pg_catalog.pg_namespace nsp
       WHERE
	   		rel.oid = con.conrelid
			AND nsp.oid = connamespace
	   		AND nsp.nspname like '<schema-name>'
			AND rel.relname like '<table-name>'

Similar codes

0 vote196 views1 answer
Sql server system messeges
SQL
5 votes213 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote202 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote205 views1 answer
Sql count null values in all columns
SQL
0 vote203 views1 answer
Select row with latest date mysql
SQL
0 vote192 views1 answer
Raven ql select count
SQL
0 vote218 views2 answers
Mysql missin expression near on
SQL
0 vote203 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote213 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
7 votes193 views1 answer
Safe update mysql
SQL