On Mon, 2006-11-13 at 08:17 -0200, Alexander Burbello wrote:
> I have one tablespace with all my objects.
> I would like to separate indexes from other.
>
> How can I select and move with SQL???
>
> Thank you for your help.
ALTER INDEX name SET TABLESPACE tablespace_name
is the approved way and quicker than re-creating the indexes.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com