Thread: Moving between databases

How would I go about moving or copying data between databases on the same
server, without actually doing a dump ?  Using an SQL statement,
something like:

SELECT dbase_a.sometable.somefield INTO dbase_b.sometable FROM dbase_a.sometable

Mark.
--

"Mark" <marks@nospam.here.net> wrote in message news:<992518353.157.0.nnrp-02.c1ed704d@news.demon.co.uk>...
> How would I go about moving or copying data between databases on the same
> server, without actually doing a dump ?  Using an SQL statement,
> something like:
> 
> SELECT dbase_a.sometable.somefield
>   INTO dbase_b.sometable
>   FROM dbase_a.sometable
> 
> Mark.
> --
Hello,
PostgreSQL doesn't support heterogenous joins between database on the same server :(
They listen it as an "exotic" feature todo. What a garbage.

Regards
Ingo