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