/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

0 vote342 views1 answer
Typescript inline switch
TypeScript
0 vote323 views1 answer
In what phaseof meiosisof prophase1 homologous chrosomes gets close to each other
TypeScript
0 vote357 views1 answer
Como agregarle un rango a mat-datapicker
TypeScript
0 vote350 views1 answer
Creating different objects in node.js
TypeScript
47 votes372 views9 answers
Cannot be loaded because running scripts is disabled on this system
TypeScript
24 votes341 views4 answers
React children typescript
TypeScript
5 votes356 views2 answers
Copy array typescript
TypeScript
0 vote349 views1 answer
Odata filter equal
TypeScript
0 vote322 views2 answers
Starts and end with vowel sql
TypeScript
-2 votes371 views1 answer
How to randomly generate a string in ts
TypeScript