Thread: how to alias a table

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

Ivan Sergio Borgonovo <mail@webthatworks.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

On Jun 13, 10:07 am, m...@webthatworks.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...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general