[GENERAL] Move table - New schema

2012-09-18 Thread 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

Re: [GENERAL] Move table - New schema

2012-09-18 Thread António Rodrigues
You were both right. It was a problem with permissions. Thank you, António On Tue, Sep 18, 2012 at 2:37 PM, Adrian Klaver adrian.kla...@gmail.comwrote: On 09/18/2012 03:48 AM, António Rodrigues wrote: Hi list, (newbie question) I'm trying to move a set of tables between schemas. Tried