Re: Explicitly adding a table to a schema.

From: Demitri Muna <thatsanicehatyouhave(at)mac(dot)com>
To: Adam Cornett <adam(dot)cornett(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Explicitly adding a table to a schema.
Date: 2011-11-04 18:32:53
Message-ID: 49D30CCA-F699-41D1-87C5-B31FDD38F61D@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On Nov 4, 2011, at 2:09 PM, Adam Cornett wrote:

> You can use ALTER TABLE (http://www.postgresql.org/docs/current/static/sql-altertable.html) to set the schema of existing tables:
> ALTER TABLE foo SET SCHEMA bar

Thanks. I did try that, but that command moves the table to a different schema, which is not what I'm trying to do. It struck me to try to move it to another schema (where the definition then explicitly included the schema prefix) and then move it back, but it still doesn't have the schema prefix.

Cheers,
Demitri

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Cornett 2011-11-04 18:37:40 Re: Explicitly adding a table to a schema.
Previous Message Martín Marqués 2011-11-04 18:31:36 Re: 9.1 replication on different arch