Postgres Pro
Downloads
Home   >   mailing lists

Re: Move indexes - Mailing list pgsql-admin

From adey
Subject Re: Move indexes
Date
Msg-id 1c66bda80611131535n25b2a610gb9cb44a080b69f52@mail.gmail.com
Whole thread Raw
In response to Move indexes  (Alexander Burbello <burbello3000@yahoo.com.br>)
List pgsql-admin
Tree view
Drop the index and recreate it in the new tablespace.

On 11/13/06, Alexander Burbello <burbello3000@yahoo.com.br> wrote:
Hi,

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.



---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate

pgsql-admin by date:

Previous
From: TomDB
Date:
Subject: replication?
Next
From: adey
Date:
Subject: Re: Issue with processes open for clients