Thread: Moving table from one schema to another

Moving table from one schema to another

From
Walter Haslbeck
Date:
Hi,

I want to move a table from one schema to another, but
'RENAME TABLE schema1.table1 TO schema2.table1' doesn't
work. Is there a better way than creating a new table with
'CREATE TABLE schema2.table1 AS SELECT * FROM schema1.table1'?

Oh, I'm using 7.4.5.

Walter