Re: how to alias a table

From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to alias a table
Date: 2010-06-13 15:32:55
Message-ID: m339wr3q3c.fsf@passepartout.tim-landscheidt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> wrote:

> I'm refactoring some code and I'll find helpful to be able to alias
> tables.

> What I'd like to do would be to refer to the same table with an
> alias in the code and later substitute the alias with an actual VIEW.

> Of course I could define a view as
> select * from original_table
> right from the start but I'm worried this may incur in some overhead
> I currently can't afford.

Have you tried it?

Tim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lew 2010-06-13 16:07:32 Re: Best way to store case-insensitive data?
Previous Message Ivan Sergio Borgonovo 2010-06-13 15:07:48 how to alias a table