On Fri, 2011-11-04 at 14:32 -0400, Demitri Muna wrote:
> 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
>
2011/11/4 Demitri Muna :
> 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 co
On Fri, Nov 4, 2011 at 2:32 PM, Demitri Muna
wrote:
> 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.
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 s
On Fri, Nov 4, 2011 at 1:57 PM, wrote:
> Hi,
>
> I have a database where I wasn't explicitly using schemas when I started
> it (i.e. everything was simply under "public"). I've since created several
> schemas and renamed the "public" schema to something else. When I look at
> the definitions (in
Hi,
I have a database where I wasn't explicitly using schemas when I started it
(i.e. everything was simply under "public"). I've since created several schemas
and renamed the "public" schema to something else. When I look at the
definitions (in PGAdmin III), the CREATE statement for the old ta
