It is a little bit different because a schema, a table or a function are database application issues and are normally addressed by pg_dump and pg_restore, although tablespaces are more an administration issue wrt disk layout and the like, which are likely to be different from one machine to another (compare with I obviously want the same schema/table/function for my application). So the notion of dump/restore of a tablespace need some careful thinking.
But maybe I'm just stupid to dream that I could restore or transfer my data even if I used a tablespace somewhere? ;-)
OK, perhaps. It it not easy to implement however, since the tablespace clause on indexes comes from the pg_get_indexdef() function and isn't added by pg_dump.
Bruce - pg_dump TODO for --no-tablespace or something?
Chris
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
