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

From Tom Lane
Subject Re: pg_dump: relation "..." already exists warning
Date
Msg-id 11340.1127015124@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump: relation "..." already exists warning  (Ennio-Sr <nasr.laili@tin.it>)
Responses Re: pg_dump: relation "..." already exists warning  (Ennio-Sr <nasr.laili@tin.it>)
List pgsql-novice
Ennio-Sr <nasr.laili@tin.it> writes:
> ...
> pg_dump finanz -t ult_qq | psql finanza ennio ult_qq    [***]
> ...
> [***] I copied this instruction somewhere from: it works,

... other than the warning it emits telling you that you've got
the psql command line syntax all wrong.  What other warnings and
error messages are you blithely ignoring?  I think you've omitted
the information needed to figure out what's wrong here.

Please post a cut-and-paste of a terminal window session showing this
sequence, not an edited transcript showing only what you think is
important.

BTW, one fairly likely guess about the problem is that you have
different schema search paths in the two databases --- so checking
the ALTER DATABASE defaults for each database wouldn't be a bad
idea.

            regards, tom lane

pgsql-novice by date:

Previous
From: Ennio-Sr
Date:
Subject: Re: pg_dump: relation "..." already exists warning
Next
From: Ennio-Sr
Date:
Subject: Re: pg_dump: relation "..." already exists warning