how to alias a table

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: how to alias a table
Date: 2010-06-13 15:07:48
Message-ID: 20100613170748.57e07c22@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Borgonovo
http://www.webthatworks.it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Landscheidt 2010-06-13 15:32:55 Re: how to alias a table
Previous Message Stephen Frost 2010-06-13 14:17:46 Re: table partition or index