SELECT conname, consrc, contype, indkey FROM (  
 SELECT  
 conname,  
 CASE WHEN contype='f' THEN  
 pg_catalog.pg_get_constraintdef(oid)  
 ELSE  
 'CHECK (' || consrc || ')'  
 END AS consrc,  
 contype,  
 conrelid AS relid,  
 NULL AS indkey  
 FROM  
 pg_catalog.pg_constraint  
 WHERE  
 contype IN ('f', 'c')  
 UNION ALL  
 SELECT  
 pc.relname,  
 NULL,  
 CASE WHEN indisprimary THEN  
 'p'  
 ELSE  
 'u'  
 END,  
 pi.indrelid,  
 indkey  
 FROM  
 pg_catalog.pg_class pc,  
 pg_catalog.pg_index pi  
 WHERE  
 pc.oid=pi.indexrelid  
 AND EXISTS (  
 SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c  
 ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)  
 WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')  
 )  
) AS sub  
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='coin_businesses'  
 AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace  
 WHERE nspname='freecoin'))