Re: Moving between databases - Mailing list pgsql-sql

From mcbang@gmx.de (Ingo Oellers)
Subject Re: Moving between databases
Date
Msg-id 8767034f.0106181313.2bbc3c18@posting.google.com
Whole thread Raw
In response to Moving between databases  ("Mark" <marks@nospam.here.net>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: Kristis Makris
Date:
Subject: Using the extract() function in plpgsql
Next
From: "Hugh Mandeville"
Date:
Subject: Re: binary data