Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help in copying a table from one database to other - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Need help in copying a table from one database to other
Date
Msg-id 20090904083524.GD8068@a-kretschmer.de
Whole thread Raw
In response to Need help in copying a table from one database to other  (Rekha Ravi Pai <rekha@softjin.com>)
List pgsql-general
Tree view 
In response to Rekha Ravi Pai :
> Hi,
> I want to copy a table say employeedetails from employee
> database to library database. Can you help me giving the
> detailed steps to do this.

pg_dump -t <insert the table-name> <insert the source-db> | psql <insert destination db>

In you case:

pg_dump -t employeedetails employee | psql library

Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)

pgsql-general by date:

Previous
From: Nickolay
Date:
Subject: Re: easy task: concurrent select-updates
Next
From: Juan Backson
Date:
Subject: strange error occurs when adding index