I had to you use pg_dump -d -D. now the import works fine !
F
Tom Lane wrote:
>Frederic Medery <dist-list(at)LEXUM(dot)UMontreal(dot)CA> writes:
>
>
>>I did a pg_dump with the -d option during the extract.
>>Inside the dump I have a lot of \012. i replace those with \n (carriage
>>return).
>>
>>
>
>Huh? \012 *is* \n. Carriage return (a/k/a \r or \015) is something
>else, and it is not what you want.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>