-----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