On Tue, 2010-12-14 at 11:34 -0800, Josh Berkus wrote:
> As for the utility of this command: there is no question that I would
> use it. I'm not sure I like the syntax (I'd prefer REPLACE TABLE ____
> WITH _____), but that's painting the bike shed.
REPLACE TABLE ying WITH yang
is probably easier to implement than hacking at the ALTER TABLE code
mountain.
> While the command may
> appear frivolous and unnecessary syntactical ornamentation to some, I
> have to say that doing the "table doesy-doe" which this command
> addresses is something I have written scripts for on at least 50% of
> my professional clients. It keeps coming up.
Yeh.
-- Simon Riggs http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services