Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 460C7650288
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 20 Oct 2008 15:35:10 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 50787-04 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 20 Oct 2008 15:34:59 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.236])
	by postgresql.org (Postfix) with ESMTP id 4A8D6650267
	for <pgsql-admin@postgresql.org>; Mon, 20 Oct 2008 15:34:58 -0300 (ADT)
Received: by qb-out-0506.google.com with SMTP id d8so1710848qbc.23
	for <pgsql-admin@postgresql.org>; Mon, 20 Oct 2008 11:34:56 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:references;
	bh=hBRykbgce0rtuhO47I9oZjJouzp9+NcvgSK4vvXDwEw=;
	b=glno0Rim35Ji9N7yidNQvkhcQgts5oCuvjfIlObsord8qEvKI3L6qfuylJgP4fe81/
	0VD/DXxokAN3Nag23NMW3I3XdoRcz8CeJx8HY6BuWil3vjr3iiJFWcmedOQTvPnAmon9
	MXC0IyEBDWxviyd6pyYFLDQcG5Evrceug8MnI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=WQ7cgVC7EezQAwQQoJD5THhsKJO2kPNgW1BIIJ4H0YjUR4NJfriPlz99NyMMN33wA+
	Cd9fcUcGeYA4RbJC/+u8b5S+qN2dimbccrBCzMmikESxzRrKKdjFVQrIwXmkrqGxomty
	v1NgV6nDqsKV/SZdGHtGhMtDU/7ZUjpBDusdQ=
Received: by 10.114.255.1 with SMTP id c1mr5697764wai.67.1224527696106;
	Mon, 20 Oct 2008 11:34:56 -0700 (PDT)
Received: by 10.114.39.11 with HTTP; Mon, 20 Oct 2008 11:34:56 -0700 (PDT)
Message-ID: <dcc563d10810201134p543abbe2vce1471fccbb1b478@mail.gmail.com>
Date: Mon, 20 Oct 2008 12:34:56 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Campbell, Lance" <lance@illinois.edu>
Subject: Re: Move tables to tablespace
Cc: pgsql-admin@postgresql.org
In-Reply-To: 
 <B10E6810AC2A2F4EA7550D072CDE876001D209A6@SAB-FENWICK.sab.uiuc.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: 
 <B10E6810AC2A2F4EA7550D072CDE876001D209A6@SAB-FENWICK.sab.uiuc.edu>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200810/140
X-Sequence-Number: 30596

On Mon, Oct 20, 2008 at 8:10 AM, Campbell, Lance <lance@illinois.edu> wrote:
> I would like to have an SQL statement that would move all of the tables and
> indexes found within a particular schema to a particular tablespace.  Is
> there a way I can do this?

I think you'll have to write a script (either external or in plpgsql)
to do this.