Re: Do not copy. Create...

[Владислав Сокол]

> the new table is meant to ultimately replace the original table

In this case the method with copying the data into new table is not safe itself, and ALTER TABLE must be applied.

> for use in a different schema

Absolutely unclear statement. Simply specify complete table name, including schema (database) name.

> in a set of related tables that are unrelated to the original table

Why? you obtain the table of needed structure with complete data copy. After this you can alter this table and integrate it into new relational scheme. Moreover, this is more suitable method when you need the existing tables in new scheme to refer to this new table.