I'm looking to move a database by using ALTER DATABASE $DB SET TABLESPACE and i'd also like to move a schema over to the same new tablespace, googling around, it looks like there was a an ALTER SCHEMA $SCHEMA SET TABLESPACE command in the past, but apparently no longer. I'm using Postgres 9, can anyone confirm if this is still possible, and if not, how I can move the schema over ?
Thanks in advance
pgsql-admin by date
|Next:||From: Guillaume Lelarge||Date: 2011-09-08 18:55:27|
|Subject: Re: Moving database and schema to a new tablespace|
|Previous:||From: marvin.deoliveira||Date: 2011-09-08 13:28:39|
|Subject: Re: corrupted rows in pg_attribute deleted|