Re: how to alias a table

From: fdd sds <kayee1995(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to alias a table
Date: 2010-06-13 16:40:43
Message-ID: edf47a22-6b21-4f00-b9fe-62c28ba296b3@y4g2000yqy.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jun 13, 10:07 am, m(dot)(dot)(dot)(at)webthatworks(dot)it (Ivan Sergio Borgonovo)
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.
>
> thanks
>
> --
> Ivan Sergio Borgonovohttp://www.webthatworks.it
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2010-06-13 19:52:32 Re: Partial indexes instead of partitions
Previous Message fdd sds 2010-06-13 16:39:29 Re: pgcon 2010 videos?