On 17/02/2009 08:09, Scott Marlowe wrote:
> ALTER TABLE name SET SCHEMA new_schema;
And you can do this for all your tables inside a transaction, making it
an all-or-nothing operation. :-)
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------