Postgres Pro
Downloads
Home   >   mailing lists

Moving rows to another database - Mailing list pgsql-general

From Mark
Subject Moving rows to another database
Date
Msg-id 992600335.655.0.nnrp-10.c1ed704d@news.demon.co.uk
Whole thread Raw
Responses Re: Moving rows to another database  (will trillich <will@serensoft.com>)
List pgsql-general
Tree view 
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.
--

pgsql-general by date:

Previous
From: Carfield Yim
Date:
Subject: Newbie question: How to check how many tables avaliable at that database?
Next
From: Jeff Waugh
Date:
Subject: Re: Permissions & Ownership (BUG?)