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 exist
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 ? O
