Hi, in short terms:
CREATE TABLESPACE http://www.postgresql.org/docs/8.1/interactive/sql-createtablespace.html CREATE TABLESPACE tablespace_name [ OWNER username ] LOCATION 'directory' ALTER INDEX http://www.postgresql.org/docs/8.1/interactive/sql-alterindex.html ALTER INDEX name SET TABLESPACE tablespace_name Haven't tried this for my own, so take care (and test). Best regards Hakan > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Alexander Burbello > Sent: Friday, November 10, 2006 8:03 PM > To: Lista Postgres > Subject: [ADMIN] Move indexes > > > 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 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] > so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
