On Friday 02 April 2010 12:44, akp geek wrote: > Hi all - > > I have created dump of a database where I have a tablespace > (data_tblspace ) associated with relations. I have restored to a different > server. I created the same table space. Now I need to create an other > database on the same server using the same dump. but I need to have a > different tablespace for all the relations. > > Can you please suggest? Do I have to do the restore the > database to the same tablespace first? and then alter the tablespace? > > > Regards
Maybe something like this (assuming the dump file is in text/sql format): sed "s/data_tblspace/new_tblspace/g" dump_file > new dump file -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
