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 ===