Re: move whole schema to a new tablespace - Mailing list pgsql-general

From Scott Marlowe
Subject Re: move whole schema to a new tablespace
Date
Msg-id dcc563d10710090736p1c49648ftb1e7232248b3ee66@mail.gmail.com
Whole thread Raw
In response to move whole schema to a new tablespace  ("Rhys Stewart" <rhys.stewart@gmail.com>)
List pgsql-general
On 10/9/07, Rhys Stewart <rhys.stewart@gmail.com> wrote:
> Hi all,
> short of issuing single commands for each table is there a way to move
> the an entire schema to a new tablespace, indices and all?

I'm pretty sure you're gonna have to write a short pl/pgsql script to do that.

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: DB upgrade
Next
From: Andrew Kelly
Date:
Subject: Re: DB upgrade