Re: pg_dump: relation "..." already exists warning - Mailing list pgsql-novice

Ennio-Sr <nasr.laili@tin.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