From: | "Aaron Bono" <postgresql(at)aranya(dot)com> |
---|---|
To: | "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: i have table |
Date: | 2006-10-09 16:01:17 |
Message-ID: | bf05e51c0610090901p6d2562acwfff1b200c086ffa9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 10/5/06, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:
>
> On Wed, Oct 04, 2006 at 11:20:07AM -0500, Aaron Bono wrote:
> >
> > So do it as needed and convert your application slowly.
>
> You don't even need to do that.
>
> ALTER TABLE tablename RENAME TO tablename_real;
>
> CREATE VIEW tablename [&c.]
>
> Now the view looks to the application just like the old table. If
> you want to insert &c., you put some rules there.
If you do this you need to make the view updateable or
inserts/updates/deletes will break.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Bono | 2006-10-09 19:57:28 | Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) |
Previous Message | Tom Lane | 2006-10-09 14:15:23 | Re: PG 8.2beta reordering working for this case? |