Postgres Pro
Downloads
Home   >   mailing lists

Re: copy tables - Mailing list pgsql-sql

From Dau Sy Manh
Subject Re: copy tables
Date
Msg-id CNEEKEDNGLPHCKEBMDPFCEPCCAAA.dsmanh@ifisolution.com
Whole thread Raw
In response to copy tables  ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
List pgsql-sql
Tree view
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.

 

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: FULL OUTER JOIN Question
Next
From: Mike Plemmons
Date:
Subject: Question about functions