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

5 votes322 views1 answer
Sql add column after another
SQL
1 vote331 views1 answer
Login to database mysql terminal
SQL
0 vote302 views1 answer
Dump db only triggers mysql
SQL
0 vote373 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote292 views1 answer
What is the use of index in mysql table
SQL
16 votes303 views3 answers
Delete row psql
SQL
2 votes307 views1 answer
Drop sequence
SQL
1 vote312 views3 answers
Union in sql
SQL
9 votes294 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
-1 vote283 views1 answer
How to use update trigger in sql
SQL