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: pgsql-admin-owner@xxxxxxxxxxxxxx > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] 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 majordomo@xxxxxxxxxxxxxx > so that your > message can get through to the mailing list cleanly >
