I work with income data linked to 19th century U.S. town names, and I have to join the income data with town points (year 2014) shapefiles. Many of the towns changed name for several times, I manually search for the current location of historical town names, and want to record such info in PostGIS.
I thought about using synonyms for a historical town names and its current town name in PostgreSQL, but it seems that PostgreSQL does not have CREATE SYNONYM statement....
Another way to do this might be changing the historical town names into its current town names in my income table, and then join with the 2014 town points shapefile, but that is my last resort since I want to keep the original town names.
Is there any other way to work around this issue?