Easy way to change table schema?

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Easy way to change table schema?
Date: 2007-08-10 15:24:23
Message-ID: 1d219a6f0708100824v6c21b62agd81f53890ffa3876@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have accidentally created some tables in the wrong schema. Since my
testers have begun to use them and put data in them, I was hoping for an
easy way to move the existing tables.

Is there a way to move tables between schema's w/o having to drop and
recreate?

Thanks,

Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2007-08-10 15:29:49 Re: Easy way to change table schema?
Previous Message Tomasz Myrta 2007-08-10 14:45:01 Re: Postgres and PAM config issues