Re: [GENERAL] Explicitly adding a table to a schema.

2011-11-04 Thread Guillaume Lelarge
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 >

Re: [GENERAL] Explicitly adding a table to a schema.

2011-11-04 Thread Pavel Stehule
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

Re: [GENERAL] Explicitly adding a table to a schema.

2011-11-04 Thread Adam Cornett
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.

Re: [GENERAL] Explicitly adding a table to a schema.

2011-11-04 Thread 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 command moves the table to a different s

Re: [GENERAL] Explicitly adding a table to a schema.

2011-11-04 Thread Adam Cornett
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