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.

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

[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 index scan if your joining column's datatypes do not
   match