[GENERAL] Move table - New schema

[António Rodrigues]

Hi list,

(newbie question)

I'm trying to move a set of tables between schemas.

Tried:

ALTER TABLE tablename
    SET SCHEMA schemaname

It gives me error: "schema schemaname does not exist" (it does)

Any help please.
Thanks,
António