Re: pg_dump & table space

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.