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 th
Alan Chandler 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
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 > ball.s
