Copying few tables from one database to another

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Copying few tables from one database to another
Date: 2011-03-06 13:43:32
Message-ID: AANLkTi=YxX31AMauUMSzqaqOK6kfGo42xS_rwXFPeyAX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

what is please the command to copy tables from 1 database
from another and is it possible at all without using pg_dump?

I'm trying to migrate 4700 users from phpBB 3 to Drupal 7
and have few custom tables in the "phpbb" database
which need to be copied over.

Using CentOS 5.5/64 bit + PostgreSQL 8.4.7

Thank you for the hints into the right direction
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vibhor Kumar 2011-03-06 13:50:06 Re: Copying few tables from one database to another
Previous Message Alban Hertroys 2011-03-06 10:45:07 Re: Why count(*) doest use index?