Re: i have table

["Aaron Bono" <postgresql(at)aranya(dot)com>]

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
==================================================================