Alan Chandler <alan(at)chandlerfamily(dot)org(dot)uk> wrote:
> [...]
> So I tried to load the same database on my home machine
> using pg_restore. This runs version 8.4.0, and it failed
> loading the restore with and error at this field "over"
> because, I presume, its a reserved word in SQL.
> Is there anyway, I can access any of my other backups and
> load the data in a current database?
a) Install an old PostgreSQL server, restore to it, change
the attribute name, dump from it, restore to a new ser-
ver.
b) Restore the backup to an SQL file, load it into a suit-
able editor, change (very carefully) "over" to the new
attribute name and restore that file to a new server.
Tim