/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

2 votes200 views2 answers
Python iterate object
TypeScript
1 vote257 views1 answer
Typescript override interface property
TypeScript
1 vote191 views1 answer
Js split at index
TypeScript
0 vote220 views1 answer
Module '"@angular/fire/firestore"' has no exported member 'AngularFirestoreCollection'
TypeScript
-1 vote205 views2 answers
ERROR in node_modules/@ng-bootstrap/ng-bootstrap/accordion/accordion.d.ts:230:9 - error TS1086: An accessor cannot be declared in an ambient context. 230 set ngbPanelToggle(panel: NgbPanel);
TypeScript
1 vote187 views1 answer
How to check when a number varibal = nan in ts
TypeScript
0 vote212 views2 answers
Https://duckduckgo.com/?t=avast Ariana Grande (@arianagrande) • Instagram photos and videoswww.instagram.com › arianagrande 203.2m Followers, 686 Following, 4664 Posts - See Instagram photos and videos from Ariana Grande (@arianagrande)
TypeScript
0 vote200 views1 answer
Cluster on lists of values that start with a certain value
TypeScript
1 vote197 views1 answer
Stored procedure that selects in to a table
TypeScript
1 vote193 views1 answer
Reduce an array of objects to string
TypeScript