Last active
October 18, 2019 15:37
-
-
Save jclarkin/5b6e801233530f9cdc19607419e3eb24 to your computer and use it in GitHub Desktop.
Postgres: Display Indexes and Constraints for a specific Table
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
nsp.nspname | |
, rel.relname | |
, 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>' | |
ORDER BY 1,2 | |
; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
n.nspname AS enum_schema | |
, t.typname AS enum_name | |
, e.enumlabel AS enum_value | |
FROM | |
pg_type t | |
JOIN pg_enum e ON t.oid = e.enumtypid | |
JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace | |
WHERE | |
n.nspname = '<schema name>' | |
ORDER BY 1,2,3 | |
; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * | |
FROM pg_indexes | |
WHERE | |
schemaname = '<schema name>' | |
AND | |
tablename = '<table name>' | |
; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment