I have a pg_dump backup which represents a slightly older version of a client dataset. A newer schema is running on the client's production environment, and there is not a readily available tool to convert the old schema into the newer one.
The only difference between the newer schema and the one represented in the backup is that some of the columns have been renamed, and a few of the types marked as
varchar have become
I was hoping there'd be something like a "mapping file" that would instruct PostgreSQL to import the data and rename/retype the columns so as to wind up with the correct result, but I think I may have to resort to pgScript instead.
Does PostgreSQL offer a facility that would make this sort of restoration operation possible?