Skip site navigation (1) Skip section navigation (2)

Re: Permanent alias for postgresql table

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Marco Lechner <marco(dot)lechner(at)geographie(dot)uni-freiburg(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Permanent alias for postgresql table
Date: 2009-03-12 14:30:03
Message-ID: 20090312143002.GH24273@eddie (view raw or flat)
Thread:
Lists: pgsql-sql
On Thu, Mar 12, 2009 at 03:26:47PM +0100, Marco Lechner wrote:
> Hi Mina,
> 
> thanks for your answer. I thought about that, but don't
> views decrease performance, because they are "calculated"
> on access?

The query gets rewritten a bit, but it's not a big deal. A more
important concern might be that to make it so you can add / modify data
in the table, you'll need to create rules to rewrite UPDATE and INSERT
queries on that view to instead affect the underlying table.

- Josh / eggyknap

In response to

pgsql-sql by date

Next:From: Thomas KellererDate: 2009-03-12 14:39:35
Subject: Re: Permanent alias for postgresql table
Previous:From: Marco LechnerDate: 2009-03-12 14:26:47
Subject: Re: Permanent alias for postgresql table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group