Re: [GENERAL] how to alias a table
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] how to alias a table
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. Have you tried it? Tim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general