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 wrote: > 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: >> >> AL

Re: [GENERAL] Move table - New schema

2012-09-18 Thread Adrian Klaver
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: ALTER TABLE tablename SET SCHEMA schemaname It gives me error: "schema schemaname does not exist" (it does) http://www.postgresql.org/docs/9.0/interac

[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