Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5KGh5a92524 for ; Wed, 20 Jun 2001 12:43:05 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5ILVSa99122 for ; Mon, 18 Jun 2001 17:31:28 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f5ILDBv71119 for pgsql-sql@postgresql.org; Mon, 18 Jun 2001 17:13:11 -0400 (EDT) (envelope-from news) From: mcbang@gmx.de (Ingo Oellers) X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Moving between databases Date: 18 Jun 2001 14:13:08 -0700 Organization: http://groups.google.com/ Lines: 17 Message-ID: <8767034f.0106181313.2bbc3c18@posting.google.com> References: <992518353.157.0.nnrp-02.c1ed704d@news.demon.co.uk> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-support@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200106/311 X-Sequence-Number: 3595 "Mark" 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