I'd like to propose the introduction of the LIKE syntax on CREATE SCHEMA command with the following syntax: CREATE SCHEMA <name> LIKE <source_schema> [like_options...
This feature is really cool.
Having a function to clone schemas is what we use for these cases, so it would be very interesting to have a command that replaces that function.
One observation is that you are using CREATE TABLE ... LIKE and this command does not respect some object names, like indexes and constraints.
Your example idx_t1_name will clone as t1_name_idx
So the cloned schema will not be exactly the same as the source.
Maybe a rename process to match names from source to target next to CREATE TABLE LIKE would solve those cases.
