/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 vote162 views1 answer
Type script
TypeScript
0 vote159 views3 answers
Cahokia mounds pictures
TypeScript
0 vote162 views1 answer
Sr.No. 18, Plot No. 5/3, CTS No.205,Behind Vandevi Temple, Karvenagar, Pune, Maharashtra
TypeScript
12 votes173 views3 answers
Loop through string js
TypeScript
0 vote170 views1 answer
The Android Gradle plugin supports only Kotlin Gradle plugin version 1.3.40 and higher. The following dependencies do not satisfy the required version: project ':video_compress' -> org.jetbrains.kotlin:kotlin-gradle-plugin:1.3.31
TypeScript
0 vote179 views1 answer
"http://" looks like a URL. Beautiful Soup is not an HTTP client. You should probably use an HTTP client like requests to get the document behind the URL, and feed that document to Beautiful Soup. markup
TypeScript
1 vote154 views1 answer
Firefox hsts clear
TypeScript
-3 votes250 views1 answer
Cool_beasts = {"octopuses":"tentacles", "dolphins":"fins", "rhinos":"horns"} for ___ in cool_beasts.items(): print("{} have {}".format(___))
TypeScript
2 votes184 views1 answer
Type of setinterval typescript
TypeScript
0 vote233 views2 answers
Error: "Filesystem" plugin is not implemented on android
TypeScript