Francisco Reyes <lists(at)stringsutils(dot)com> 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