Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1A7859FB27F for ; Mon, 13 Nov 2006 19:35:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11814-04 for ; Mon, 13 Nov 2006 19:35:28 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by postgresql.org (Postfix) with ESMTP id EDE459FB27C for ; Mon, 13 Nov 2006 19:35:27 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so53910nfb for ; Mon, 13 Nov 2006 15:35:26 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=tQHESl4rAvJP7yjNgGWlj4NdNwWzX6/iHoRJ63gMuGhkLdNjXSahy4ZE6t6axbA/eLUORfuu8COTBowmN9AsUuoCC6pq74KmC+6R4w0DCtT0MgAChoCJoKAf/5BaP8+Miaob8V0LgOSGn2KAj6VqEeSIj4fIlJkThuvglyQ5/dY= Received: by 10.82.131.1 with SMTP id e1mr27989bud.1163460925751; Mon, 13 Nov 2006 15:35:25 -0800 (PST) Received: by 10.82.173.15 with HTTP; Mon, 13 Nov 2006 15:35:25 -0800 (PST) Message-ID: <1c66bda80611131535n25b2a610gb9cb44a080b69f52@mail.gmail.com> Date: Tue, 14 Nov 2006 12:35:25 +1300 From: adey To: "Alexander Burbello" Subject: Re: Move indexes Cc: "Lista Postgres" In-Reply-To: <4558463C.9070502@yahoo.com.br> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_14775_11760258.1163460925704" References: <4558463C.9070502@yahoo.com.br> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/127 X-Sequence-Number: 23654 ------=_Part_14775_11760258.1163460925704 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Drop the index and recreate it in the new tablespace. On 11/13/06, Alexander Burbello 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 > ------=_Part_14775_11760258.1163460925704 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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

------=_Part_14775_11760258.1163460925704--