How come that statement don't copy constraints if I explicitly ask for it?
CREATE TABLE backup_schema.permissions (LIKE public.permissions INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES INCLUDING STORAGE INCLUDING COMMENTS);
INSERT INTO backup_schema.permissions
SELECT *
FROM public.permissions
WHERE community_id=123;
verifying with pgadmin3 I discovered that constraints on the new table(eg.:backup_schema) was:
but in the original table in public schema was like this: