X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id A2AAAD1B1CB
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 19 May 2004 13:38:53 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 96726-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 19 May 2004 13:38:34 -0300 (ADT)
Received: from web13806.mail.yahoo.com (web13806.mail.yahoo.com
	[216.136.175.16])
	by svr1.postgresql.org (Postfix) with SMTP id B0B8FD1B19D
	for <pgsql-sql@postgresql.org>; Wed, 19 May 2004 13:38:32 -0300 (ADT)
Message-ID: <20040519163832.88907.qmail@web13806.mail.yahoo.com>
Received: from [216.173.173.66] by web13806.mail.yahoo.com via HTTP;
	Wed, 19 May 2004 09:38:32 PDT
Date: Wed, 19 May 2004 09:38:32 -0700 (PDT)
From: Chris Gamache <cgg007@yahoo.com>
Reply-To: cgg007@yahoo.com
Subject: SCHEMA's the easy way?
To: pgsql-sql@postgresql.org
In-Reply-To: <40AB7272.2090605@mk-os.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0
	tests=FROM_ENDS_IN_NUMS, UPPERCASE_25_50
X-Spam-Level: *
X-Archive-Number: 200405/166
X-Sequence-Number: 17880

I'm planning on dipping my toes into the world of schemata. I have tables,
created in the Public schema, that I'd like to move to the new schema:

SELECT * INTO new.tablename FROM public.tablename;
CREATE SEQUENCE ...;
CREATE INDEX ...;
ALTER TABLE ...;
BLAH ...;
BLAH ...;
BLAH ...;
DROP public.tablename;
REPEAT ...;
REPEAT ...;
REPEAT ...;
VOMIT;

Is there an easier, faster, less user-error-prone way around this? 


	
		
__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/