Hi, you may try following.
You can create a one more table-space by using following command, -- Tablespace: "tablespace - name " -- DROP TABLESPACE tablespace_name CREATE TABLESPACE tablespace_name OWNER "UserName" LOCATION 'path '; -- path for table-space And move the existing object to other tablespace using following command psql>ALTER TABLE table_name SET TABLESPACE tablespace_name; Next, while adding new object take care of defining the tablespace name also. On Mon, 2008-12-08 at 14:20 -0800, Isabella Ghiurea wrote: > Dear pg Gurus, > I would like to know : > 1- how can I alter an existing db on new table space, is there a cmd > :alter db add tablespace2 etc ? > 2- how can in create db allocate 2 -n tables spaces for a db ? " create > db name with tablespace 1= .. and tablespace2=.... "will this be a > valid cmd ? Or other solution to this issues ? > using Pg version 8.3 on Linux > Thank you in advance > Isabella > > > Thanks & Regards, Suresh Borse (DBA) _________________________________________________________________________________________ DIRECTION SOFTWARE SOLUTIONS 5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, Mumbai - 400 013 Tel. : 91 22 66615000 (Ext: 350) Fax : 91 22 24911046 Cell : 91 9422 239338 Site : www.direction.biz _________________________________________________________________________________________
