Quick Links

Re: ALTER TABLE ... REPLACE WITH

From:	bricklen <bricklen(at)gmail(dot)com>
To:	Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:	pgsql-hackers(at)postgresql(dot)org
Subject:	Re: ALTER TABLE ... REPLACE WITH
Date:	2010-12-17 00:19:48
Message-ID:	AANLkTikXfcJVctRHyZjB8=eeJCNULkxY1sxS6iAMY=fk@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

On Wed, Dec 15, 2010 at 2:39 AM, Simon Riggs <simon(at)2ndquadrant(dot)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?

In response to

Re: ALTER TABLE ... REPLACE WITH at 2010-12-15 10:39:56 from Simon Riggs

Responses

Re: ALTER TABLE ... REPLACE WITH at 2010-12-17 07:05:05 from Simon Riggs

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Itagaki Takahiro	2010-12-17 02:00:00	Re: SQL/MED - file_fdw
Previous Message	David Fetter	2010-12-16 23:32:56	Re: Tab completion for view triggers in psql