pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: i have table
Date: Thu, 5 Oct 2006 11:29:52 -0400
Message-ID: <20061005152952.GA8826@phlogiston.dyndns.org> (raw)
In-Reply-To: <bf05e51c0610040920x329f3c79u9fdaed0d490f8bb1@mail.gmail.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C9073DCD8F@venus.infics.com>
<45237D6E.1030601@logix-tt.com>
<4523C3E2.4010300@myemma.com>
<bf05e51c0610040754o101408c2y8a743697b9ceee4@mail.gmail.com>
<4523D51F.4070208@myemma.com>
<bf05e51c0610040920x329f3c79u9fdaed0d490f8bb1@mail.gmail.com>
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.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
--Damien Katz
view thread (19+ messages) latest in thread
Message-ID: <20061005152952.GA8826@phlogiston.dyndns.org> Permalink: ../20061005152952.GA8826@phlogiston.dyndns.org/ Also on: postgresql.org/message-id/20061005152952.GA8826@phlogiston.dyndns.org ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-sql@postgresql.org Cc: ajs@crankycanuck.ca Subject: Re: i have table In-Reply-To: <20061005152952.GA8826@phlogiston.dyndns.org> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox