Yes you can do this using following commands.
For tables:-
select ' alter table '||tablename||' set tablespace ;'
from pg_tables where schemaname='' and tableowner='<
mention table owner here >';
For index :-
select ' alter index '||indexname||' set tablespace ;'
from pg_indexes where schemanam
On Mon, Oct 20, 2008 at 8:10 AM, Campbell, Lance <[EMAIL PROTECTED]> wrote:
> I would like to have an SQL statement that would move all of the tables and
> indexes found within a particular schema to a particular tablespace. Is
> there a way I can do this?
I think you'll have to write a script (e
