| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | SUBHAM ROY <subham(dot)iem(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Needs Suggestion |
| Date: | 2011-04-19 22:55:02 |
| Message-ID: | 9153883C-772A-4E48-9B28-FBF2D16BE0EE@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Apr 20, 2011, at 4:08 AM, SUBHAM ROY wrote:
> Suppose Postgres is installed in two computers C1 & C2.
> C1 have some database tables. How can I copy these database tables from C1 to C2.
> I mean to say that can I copy tables from postgres installed in one m/c to another m/c.
> Is there any command in postgres to do so or any other short cut technique.
Use pg_dump/pg_restore command to copy the tables from One database to another.
http://www.postgresql.org/docs/9.0/interactive/backup-dump.html
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-04-19 23:03:27 | Re: getting to beta |
| Previous Message | SUBHAM ROY | 2011-04-19 22:38:01 | Needs Suggestion |