Postgres Pro
Downloads
Home   >   mailing lists

Re: Easy way to change table schema? - Mailing list pgsql-admin

From Chris Hoover
Subject Re: Easy way to change table schema?
Date
Msg-id 1d219a6f0708101048y616a08a0td52191860ec7665f@mail.gmail.com
Whole thread Raw
In response to Re: Easy way to change table schema?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Tree view
On 8/10/07, Joshua D. Drake <jd@commandprompt.com> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Chris Hoover wrote:
> 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?

ALTER TABLE

http://www.postgresql.org/docs/current/interactive/sql-altertable.html



>
> Thanks,
>
> Chris
>


- --

thanks, I must be blind in one eye and unable to see out of the other.  I was looking at the page before I sent out my inquiry and did not see it.

Chris


pgsql-admin by date:

Previous
From: "Mark Steben"
Date:
Subject: Mass updates on a large table
Next
From: "Scott Marlowe"
Date:
Subject: Re: Mass updates on a large table