Tim Landscheidt wrote:
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.
Thats what I had hoped to be able to do (I've got to search several
backups for the one with the
I built an application last year which used the name over as the name
of a boolean field in one of the tables.
It was in regular use last year and worked fine.
I have been regularly taking backups with of this database with the
following command
pg_dump -Fc melindas_ball | gzip -9
Alan Chandler a...@chandlerfamily.org.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