Horton

Re: ALTER TABLE ... REPLACE WITH

bricklen <bricklen@gmail.com>

View thread
From: bricklen <bricklen@gmail.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2010-12-17T00:19:48Z
Lists: pgsql-hackers 
On Wed, Dec 15, 2010 at 2:39 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Perhaps a more useful definition would be
>
> EXCHANGE TABLE target WITH source;
>
> which just swaps the heap and indexes of each table.

At the risk of stating the obvious, this would work with partition exchange too?