move whole schema to a new tablespace
Started by Rhys A.D. Stewartover 18 years ago2 messagesgeneral
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?
Re: move whole schema to a new tablespace
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.