Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> running the command:
> $ pg_dump finanz -t ult_qq | psql finanza ennio ult.qq
> I can see that table 'ult_qq' is regularly created in 'finanza' and
> continues to exist in 'finanz', although pg is firing this warning:
> SET
> SET
> SET
> SET
> ERROR: relation "ult_qq" already exists
> SET
> ERROR: relation "ult_qq" already exists
> SET
> SET
> which I'm unable to explain.
It seems fairly easily explainable to me: the table already exists.
Perhaps because you already restored into this destination database?
regards, tom lane