Postgres Pro
Downloads
Home   >   mailing lists

Moving database and schema to a new tablespace - Mailing list pgsql-admin

From Richard Shaw
Subject Moving database and schema to a new tablespace
Date
Msg-id 9BD8BDB8-C1D6-4683-8011-95C0E66F3AAB@aggress.net
Whole thread Raw
Responses Re: Moving database and schema to a new tablespace  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
Tree view 
Hi,

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
thesame new tablespace, googling around, it looks like there was a an ALTER SCHEMA $SCHEMA SET TABLESPACE command in
thepast, but apparently no longer.   I'm using Postgres 9, can anyone confirm if this is still possible, and if not,
howI can move the schema over ? 

Thanks in advance

Richard

pgsql-admin by date:

Previous
From: "marvin.deoliveira"
Date:
Subject: Re: corrupted rows in pg_attribute deleted
Next
From: Guillaume Lelarge
Date:
Subject: Re: Moving database and schema to a new tablespace