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 === ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
