Keyboard shortcuts for VS Code search modes
VS Code search supports match case, match whole word, and use regular expression modes. These modes can toggled by pressing cmd + option + c, w, or r for case, word, and regular expression respectively.
Get constraint definition in PostgreSQL
pg_get_constraintdef can be used to get the SQL definition of a constraint.
select pg_get_constraintdef(oid) from pg_constraint where conname='users_tenant_id_fkey';
-- => FOREIGN KEY (tenant_id) REFERENCES tenants(id) ON DELETE CASCADE