Re: robust way of moving tables to a different disk??

Sam Mortimer <sam.mortimer@gmail.com> writes:
> I'd like to move some tables from a particular database onto a
> different set of disks.  However, I can't see any robust way of
> achieving this.

PG 8.0 can do this using tablespaces.  There isn't any particularly
nice solution in earlier versions.  If you want to move an entire
*database*, you can do it with the "alternate locations" feature,
but not table-by-table.

            regards, tom lane