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: