Moving rows to another database

From: "Mark" <marks(at)nospam(dot)here(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Moving rows to another database
Date: 2001-06-15 10:18:40
Message-ID: 992600335.655.0.nnrp-10.c1ed704d@news.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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-general by date

  From Date Subject
Next Message Marcel Gsteiger 2001-06-15 10:25:10 problems with mod_auth_pgsql
Previous Message Matteo Centenaro 2001-06-15 08:42:54 Insert and limit