Home > mailing lists

Re: copy tables - Mailing list pgsql-sql

From	A. Kretschmer
Subject	Re: copy tables
Date	October 14, 2005 07:25:56
Msg-id	20051014072543.GG10299@webserv.wug-glas.de Whole thread Raw
In response to	copy tables ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Greg Stark
Date: 14 October 2005, 07:21:14
Subject: Re: pg, mysql comparison with "group by" clause

From: "Shavonne Marietta Wijesinghe"
Date: 14 October 2005, 08:44:22
Subject: copy table

Re: copy tables - Mailing list pgsql-sql

Previous

Next