Re: copy tables

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: copy tables
Date: 2005-10-14 07:25:43
Message-ID: 20051014072543.GG10299@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

am 14.10.2005, um 8:54:39 +0200 mailte Shavonne Marietta Wijesinghe folgendes:
> Hello
>
> I have 2 postgreSQL databases called "DATA1" and "DATA2" with several tables inside them (table A, B, C).
>
> I modify the details in table "A" in database "DATA1"
>
> How can I copy table "A" from database "DATA1" and paste it in database "DATA2" using the same table name ??

Backup the table A from DATA1 and restore it into DATA2.

(pg_dump with -t dumps only the specified table)

Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

In response to

  • copy tables at 2005-10-14 06:54:39 from Shavonne Marietta Wijesinghe

Browse pgsql-sql by date

  From Date Subject
Next Message Shavonne Marietta Wijesinghe 2005-10-14 08:44:13 copy table
Previous Message Greg Stark 2005-10-14 07:21:01 Re: pg, mysql comparison with "group by" clause