Re: [GENERAL] move whole schema to a new tablespace

2007-10-09 Thread Scott Marlowe
On 10/9/07, Rhys Stewart <[EMAIL PROTECTED]> 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. --

[GENERAL] move whole schema to a new tablespace

2007-10-09 Thread Rhys Stewart
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? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an i