Re: Can you help solve restore problem?

Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> May I ask how to 'edit the COPY commands'? Perhaps you mean to edit the
> dump file and add "WITH NULL AS '-' " ?

Yeah.

> Mmmh, I tried to add that in the dump file (at the end of the COPY
> command) and got these errors:
> You are now connected as new user "ennio"
> SET
> ERROR: relation "dep_tit" already exists
> ERROR: relation "s_cod_rif" already exists # this is a sequence
> ERROR: relation "gar_tit" already exists
> ERROR: syntax error at or near "Data" at charachter 4
> ERROR: syntax error at or near "Type" at charachter 2
> ERROR: syntax error at or near "Schema" at charachter 2
> ERROR: syntax error at or near "Owner" at charachter 2
> invalid comman \.
> ERROR: syntax error at or near "1" at character 1

You didn't show what you did, but this looks a bit like you messed up
the comment for the next item in the dump script.

regards, tom lane