Stephen Davies <scldad(at)sdc(dot)com(dot)au> writes:
> I have just had to restore a database from backup because the majority
> of records in one table had "magically" become null.
There's no such thing as a null record in Postgres. What do you mean
exactly: were the records still present but their fields all read as
nulls?
What is the declaration of the table?
regards, tom lane