Postgresql - Add/ Remove Unique Constraint

 ALTER TABLE mydatabase.tablename DROP CONSTRAINT constraintname;

ALTER TABLE mydatabase.tablename DROP ADD CONSTRAINT constraintnameUNIQUE  (name, ad_org_id);

Postgresql - List Constraints

 SELECT r.relname,c.* FROM pg_catalog.pg_constraint c

INNER JOIN pg_catalog.pg_class r ON r.oid = c.conrelid

INNER JOIN pg_catalog.pg_namespace n ON n.oid = connamespace 

WHERE n.nspname = 'mydatabase' AND conname = 'anyconstraintnamea'

Postgresql List Index

 SELECT TABLENAME,INDEXNAME,INDEXDEF FROM PG_INDEXES 

WHERE SCHEMANAME = 'mydatabase' ORDER BY TABLENAME,INDEXNAME;

Postgresql - Turn off triggers

 SET session_replication_role = replica;

Postgresql - ADD/ REMOVE - DEFAULT VALUE FROM A COLUMN

 -- EXAMPLE: MY_TABLE_NAME HAVE A DEFAULT TOTAL OF 0 

ALTER TABLE MY_TABLE_NAME ALTER COLUMN TOTAL_CENTS SET DEFAULT 0;

-- EXAMPLE: MY_TABLE_NAME ARE AVAILABLE BY DEFAULT

ALTER TABLE MY_TABLE_NAME ALTER COLUMN AVAILABLE SET DEFAULT TRUE;

ALTER TABLE MY_TABLE_NAME ALTER COLUMN TOTAL_CENTS DROP DEFAULT;

Postgresql - ADD NOT NULL & REMOVE NOT NULL CONSTRAINT

 ALTER TABLE MY_TABLE_NAME ALTER COLUMN EMAIL SET NOT NULL;

ALTER TABLE MY_TABLE_NAME ALTER COLUMN EMAIL DROP NOT NULL;

Postgresql - Add/Remove primary key

 ALTER TABLE MY_TABLE_NAME ADD PRIMARY KEY (COLUMN_1, COLUMN_2);

ALTER TABLE MY_TABLE_NAME DROP CONSTRAINT TEST1_PKEY;