Re: Move a table to another schema

Julie May wrote:

> When I have contemplated doing this, I figured I would just dump the
> database, then alter the search patch and put in the schema name I wanted
> instead of public and theoretically the tables and data should be recreated
> in the new schema. I would create the new schema first.
> 
> Julie
> 
> 
>>I have many tables created in the "public" schema and I would like to
>>migrate these into an "x001" schema. Unfortunately there is no ALTER
>>TABLE construct for this... The following SQL would seem to move the
>>"zxc" table from "public.zxc" to "x001.zxc":

Why not just rename the schema itself? You can recreate a public schema later..:-)

Simple, isn't it? (Unless public is a specieal schema)

  Shridhar