I want to copy a table from one database into the other one.
I found this
Myproblem is how to reference externaldatabase I tried with "database2.schemat2.new_table_name" but it did not work. database2 runs at the same server as database1 containing old_table_name so the user, password, port, host is the same for both databases.
Is there any other way to do this (except pg_dump)?
Thanks

in oracle you do it like

from tab@db
i think in postgresql you can do it similar

Hi Krontrex,

I did not think it was possible to copy from one database to another in PostgreSQL. However, I dont know all the available options.

If
works, then the syntax you are after would be:

That statement would need to be run from the Original Database.