Thread: Is it possible to move a database to another tablespace?

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?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 04/19/07 14:51, Francisco Reyes wrote:
> 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?

Move one table at a time?

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGJ95KS9HxQb37XmcRAloBAKDC+j/yS4r6dQXiY2kKUQMXUaHtYgCggy+A
JIeqTvU4Q4zZR+gX9q/6mNk=
=bIOU
-----END PGP SIGNATURE-----

Francisco Reyes <lists@stringsutils.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