Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2EC719F981C for ; Fri, 10 Aug 2007 14:49:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 08725-01 for ; Fri, 10 Aug 2007 14:49:00 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 777A89F9813 for ; Fri, 10 Aug 2007 14:49:01 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id f5so342646nfh for ; Fri, 10 Aug 2007 10:49:00 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=NXwIpqGtgUealbmq4YPHuiCAIU7B4DDR07LZ4dTi5Zcy7Aq3UYQ7NkXZw10qXDgdmoFtbyAsSZEg/wabi0ACZAqEMhc5+X6SJVdJgxzez8izwO75WeJvac6lo8tB7kX7m6dfrxWJdH77kUJBAC4RmwRIvJw5/5JjvnfeC33bCF0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Ms2PYWXZwmj/7PeE8omxo4mKETZXkUUrMgK7cSWrAUMCCCd93SwNSETiXcLX/JiqJqpv0HSkQwHdY7C0w9Sm+jEAW7VsHhzRIC042mD6yIv8V820XVbBVkteFDiLyEecTW5ElbDE8qxGo0ANOQu40qmyUWPbpx8v0tlUl+aHVRA= Received: by 10.78.170.6 with SMTP id s6mr1441891hue.1186768136812; Fri, 10 Aug 2007 10:48:56 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Fri, 10 Aug 2007 10:48:56 -0700 (PDT) Message-ID: <1d219a6f0708101048y616a08a0td52191860ec7665f@mail.gmail.com> Date: Fri, 10 Aug 2007 13:48:56 -0400 From: "Chris Hoover" To: "Joshua D. Drake" Subject: Re: Easy way to change table schema? Cc: "pgsql-admin@postgresql.org Admin" In-Reply-To: <46BC846D.6010109@commandprompt.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_159865_3471784.1186768136726" References: <1d219a6f0708100824v6c21b62agd81f53890ffa3876@mail.gmail.com> <46BC846D.6010109@commandprompt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/123 X-Sequence-Number: 26454 ------=_Part_159865_3471784.1186768136726 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 8/10/07, Joshua D. Drake 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 ------=_Part_159865_3471784.1186768136726 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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


------=_Part_159865_3471784.1186768136726--