I want to create a view of a table with a column renamed. I do not want to effect the source table, just the view.
I need to rename the column addr:housename to addr_housename. We have a 3rd party piece of software that does not like ':' in field names. We cannot just rename the field due to other software we use.
Can someone please provide an example on how to resolve my issue?
Thank you very much.