Stephen Frost <sfrost@snowman.net> writes:
> That it's more-or-less a bulk 'ALTER TABLE' operation is why I had been
> trying to think of a way to put it under that command. What if we had a
> more general way to reference 'all objects in a tablespace'?
> "tablespace.*" or "ALL:TABLESAPCE"? Are there other places which might
> benefit from being able to take and operate on all objects in a
> tablespace?
> Of course, we handle this in 'GRANT' with 'GRANT ON ALL TABLES', so why
> not 'ALTER TABLE ON ALL TABLES IN TABLESPACE <blah>'? that does get
> pretty darn verbose but is at least a bit more in-line with what we have
> done before..
That's not a bad line of thought --- I doubt that verbosity is critical
here.
regards, tom lane