Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group