"M. Roscio" <mroscio(at)tin(dot)it> writes:
> However I insist about foreign keys: source table is present with 13
> rows in information_schema.key_column_usage,
> while destination table only has one.
LIKE is not documented as copying foreign key constraints, regardless
of whether there's a primary key or not. INCLUDING CONSTRAINTS
is specifically stated to control CHECK constraints only.
regards, tom lane