/TypeScript/How to see constraints in postgresql

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

34 votes233 views4 answers
How to get duplicate elements in sql
TypeScript
0 vote206 views1 answer
How to check if folder already exists in google drive python
TypeScript
0 vote224 views1 answer
W to check whether an image is a broken image or not in typescript angular
TypeScript
0 vote227 views1 answer
PYTHON STACK FUNCTION count the valid number of brackets Returns the total number of valid brackets in the string
TypeScript
13 votes242 views4 answers
Ionic generate resources
TypeScript
0 vote220 views1 answer
Do you use data structures in your current automation project
TypeScript
3 votes220 views2 answers
Lua print all elements table
TypeScript
0 vote213 views2 answers
Removing alphabets from a string in python
TypeScript
0 vote236 views1 answer
Print query from get_posts wordpress
TypeScript
0 vote240 views1 answer
Angular 12 model class
TypeScript