Need one table with two names

[Charlie Dawn]

I would like to add a second, alternate name to an existing table to facilitate migration issues.

For example, say I have a table called "zips". I now want to have this table also be called "postalcodes" and be able to select from this single table equally well by either name. The idea is that once all the code is changed from "zips" references to "postalcodes" references, the "zips" name can be retired. (Oh, it would be great to have a way to "see" which name is being used in database requests to double-check before the "retirement".)

I think this is clear. Ideally, the scheme would add the second name as a one-time database change rather than as something that needs to be set up each time the database is opened or the table is referenced, but I'll take what is available (duh).

Thanks