On Friday 14 September 2007, "Harsh Azad" <[EMAIL PROTECTED]> wrote:
> Great, creating new tablespace for indexes worked! Now the question is
> whether existing tables/index can be moved to the new tablespace using an
> alter command or the only way possible is to drop and recreate them?
>
ALTER TABLE table_name set tablespace new_tablespace;
and ALTER INDEX ...
--
Eat right. Exercise regularly. Die anyway.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
