Re: [GENERAL] pg_dump & table space

2009-06-01 Thread Alvaro Herrera
Tom Lane wrote: > However, this is really just cosmetic, as the dump is set up like this: > > SET default_tablespace = whatever; > CREATE TABLE whichever(...); > > If tablespace 'whatever' doesn't exist, you'll get an error on the SET > but the CREATE will succeed anyway. (I guess this only wor

Re: [GENERAL] pg_dump & table space

2009-06-01 Thread Tom Lane
Luca Ferrari writes: > 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 achie

Re: [GENERAL] pg_dump & table space

2009-06-01 Thread John R Pierce
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). A

Re: [GENERAL] pg_dump & table space

2009-06-01 Thread John R Pierce
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

[GENERAL] pg_dump & table space

2009-05-31 Thread Luca Ferrari
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? Thanks