John R Pierce wrote:
> 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.
oh, dump the schema only first, edit that, then dump the data only to a
seperate dumpfile, thats probably simplest.