Thread: move whole schema to a new tablespace

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?

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.