Francisco Reyes <[EMAIL PROTECTED]> writes:
> I see tables and indexes can be moved to a different tablespace.
> Is there any way to move an entire database to a different tablespace?
No. Moving the system catalogs on-the-fly would be an interesting
problem ("uh, where did you say pg_class was? ... and I can't find its
indexes either?"). It could possibly be done, but the complexity would
be far out of proportion to the value I fear.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq