pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

copy tables
3+ messages / 3 participants
[nested] [flat]

* copy tables
@ 2005-10-14 06:54 Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
  2005-10-14 07:25 ` Re: copy tables A. Kretschmer <andreas.kretschmer@schollglas.com>
  2005-10-15 02:38 ` Re: copy tables Dau Sy Manh <dsmanh@ifisolution.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Shavonne Marietta Wijesinghe @ 2005-10-14 06:54 UTC (permalink / raw)
  To: pgsql-sql

 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. 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: copy tables
  2005-10-14 06:54 copy tables Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
@ 2005-10-14 07:25 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
  1 sibling, 0 replies; 3+ messages in thread

From: A. Kretschmer @ 2005-10-14 07:25 UTC (permalink / raw)
  To: 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    === 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: copy tables
  2005-10-14 06:54 copy tables Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
@ 2005-10-15 02:38 ` Dau Sy Manh <dsmanh@ifisolution.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Dau Sy Manh @ 2005-10-15 02:38 UTC (permalink / raw)
  To: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>; pgsql-sql

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.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2005-10-15 02:38 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-14 06:54 copy tables Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
2005-10-14 07:25 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2005-10-15 02:38 ` Dau Sy Manh <dsmanh@ifisolution.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox