Re: Move tables to tablespace - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Move tables to tablespace
Date
Msg-id dcc563d10810201134p543abbe2vce1471fccbb1b478@mail.gmail.com
Whole thread Raw
In response to Move tables to tablespace  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Shane Ambler
Date:
Subject: Re: 32bit data on 64bit machine?
Next
From: FM
Date:
Subject: Privileges on sequences