Re: ALTER TABLESPACE ... MOVE ALL TO ...

Stephen Frost <sfrost@snowman.net> writes:
> So you're still looking for an 'OWNED' noise word to be added?  Also, I
> did add the ability to specify types of objects (it's often that we'll
> have a "INDEXES" tablespace, so this made sense), so how about:

> ALTER TABLESPACE name MOVE OWNED TO name opt_nowait
> ALTER TABLESPACE name MOVE TABLES OWNED TO name opt_nowait
> ALTER TABLESPACE name MOVE INDEXES OWNED TO name opt_nowait
> ALTER TABLESPACE name MOVE MATERIALIZED VIEWS OWNED TO name opt_nowait

> Removing the 'ALL' entirely?

What if you're a superuser and you want to move everybody's objects
(perhaps in preparation for dropping the tablespace)?  I think there's
value in both the ALL and OWNED forms.
        regards, tom lane