Re: Can you help solve restore problem?

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [231104, 14:37]:
> Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> > This is an extract of the dump file:
>
> [...]
>
> If that is the correct analysis then the easiest fix is probably to edit
> the COPY commands to add WITH NULL AS '-' (this assumes that you don't
> have any fields where '-' would actually be the value).
>

> > May I ask how to 'edit the COPY commands'? Perhaps you mean to edit the
> > dump file and add "WITH NULL AS '-' " ?

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

I also tried to cut the last two columns to no avail.
May be a should correct the original table before dumping it?

Regards,
Ennio

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]