Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE ... REPLACE WITH - Mailing list pgsql-hackers

From bricklen
Subject Re: ALTER TABLE ... REPLACE WITH
Date
Msg-id AANLkTikXfcJVctRHyZjB8=eeJCNULkxY1sxS6iAMY=fk@mail.gmail.com
Whole thread Raw
In response to Re: ALTER TABLE ... REPLACE WITH  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: ALTER TABLE ... REPLACE WITH  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
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?

pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Tab completion for view triggers in psql
Next
From: Itagaki Takahiro
Date:
Subject: Re: SQL/MED - file_fdw