Moving between databases

From: "Mark" <marks(at)nospam(dot)here(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Moving between databases
Date: 2001-06-14 11:32:20
Message-ID: 992518353.157.0.nnrp-02.c1ed704d@news.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.
--

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2001-06-14 12:02:52 Re: Getting a specific row from a table
Previous Message Gary Stainburn 2001-06-14 08:40:34 search/replace in update