Luca Ferrari wrote:
Hi,
is there a way to dump an entire database which has a specific table space
without having in the sql file any reference to the tablespace? This can be
useful when moving the database from one machine to another (that does not use
the tablespace). Any way to achieve that with pg_dump?
dump in ascii format, edit the resultant SQL file and remove any
references to the tablespace. this could probably be done with a perl
or sed script if the file is too large for a conventional text editor.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
