Re: Move table - New schema

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(dot)klaver(at)gmail(dot)com>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:
>>
>> ALTER TABLE tablename
>> SET SCHEMA schemaname
>>
>> It gives me error: "schema schemaname does not exist" (it does)
>>
>
> http://www.postgresql.org/**docs/9.0/interactive/sql-**altertable.html<http://www.postgresql.org/docs/9.0/interactive/sql-altertable.html>
>
> "You must own the table to use ALTER TABLE. To change the schema of a
> table, you must also have CREATE privilege on the new schema"
>
> Are you doing the above as the owner of the table and does the owner have
> CREATE privileges on the new schema?
>
>
>
>> Any help please.
>> Thanks,
>> António
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>