Re: pg_dump: relation "..." already exists warning

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [170905, 23:45]:
> Ennio-Sr <nasr(dot)laili(at)tin(dot)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

OK, reading Doc Manuals (pg 8), III,22.1.1 ('Restoring the dump') -
which I should have done before ... :-) ) I realize that command is
intented for dumping a db directly from one _server_ to another, whereas I
was using it to copy a table in _db_ n.1 to _db_ no.2, in which case the
correct line would be:

pg_dump finanz -t ult_qq > foo | psql finanza ennio < foo

which doesn't emit any warning. May be there is a better way to achieve
my goal (i.e.: using a few values of db n.1 table from within db n.2):
perhaps SCHEMA, but I couldn't understand how this works on my first
reading.

Back to your answer, I'm not sure I understand correctly what you're
requiriring me to do (in particular, I found no instructions on how to
check the ALTER DATABASE defaults right now).
The lines I posted in my original message are not 'an edited transcript'
though the result of piping to foo whatever was produced by the command
( psql finanz ...... > foo 2&>1).

BUT, wait a minute ...
After a few tests (while writing this) I discovered the error came out
because there was a schema which I forgot to drop when I realized I
couldn't understand how it was supposed to work ;-)

Having dropped the schema, both commands work with no error :-)

Sorry for wasting your time.
Regards,
Ennio.

PS: Could a valid schema allow me to utilize a table in a db from
another db?

--
[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) ]