Postgres Pro
Downloads
Home   >   mailing lists

Thread: copy tables

copy tables

From
"Shavonne Marietta Wijesinghe"
Date:
 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 ??

Thank you.

 

Re: copy tables

From
"A. Kretschmer"
Date:
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    ===

Re: copy tables

From
"Dau Sy Manh"
Date:
In DATA1 you run SQL Query:
copy A to 'PATH\tempA.txt'
 
Then in DATA2 you run SQL Query:
copy A from 'PATH\tempA.txt'
 
good luck !
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Shavonne Marietta Wijesinghe
Sent: vendredi 14 octobre 2005 13:55
To: pgsql-sql@postgresql.org
Subject: [SQL] copy tables

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

Thank you.