Re: Move tables to tablespace

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Move tables to tablespace
Date: 2008-10-20 18:34:56
Message-ID: dcc563d10810201134p543abbe2vce1471fccbb1b478@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Oct 20, 2008 at 8:10 AM, Campbell, Lance <lance(at)illinois(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message FM 2008-10-20 19:58:45 Privileges on sequences
Previous Message Shane Ambler 2008-10-20 17:02:22 Re: 32bit data on 64bit machine?