aryan26gupta

Simple cheatsheet

(thanks mr. apollo): https://gist.github.com/apolloclark/ea5466d5929e63043dcf

Query to fetch all constraints on a table:

SELECT
    con.conname AS constraint_name,
    con.contype AS constraint_type,
    pg_get_constraintdef(con.oid) AS constraint_definition
FROM