On 10/9/07, Rhys Stewart <rhys.stewart@xxxxxxxxx> 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