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>';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>'Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
