| From: | Jorge Alberto Fuentes Casillas <buen_sama(at)yahoo(dot)com(dot)mx> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Table transfer |
| Date: | 2010-09-21 21:28:05 |
| Message-ID: | 548193.20981.qm@web112410.mail.gq1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Good day to all of you.
Currently i have 2 databases in my postgresql server, and i want to transfer
the data from my db1.table1 to my db2.table2.
Both of the tables are very simmilar from each other, so, what i want to do, is
to transfer mostly of the rows from one table to the other. I was wondering if
you could please help me on how doing this, what i want to know, is if there's
something like this:
NSERT INTO db1.table_1 (table1_row1,table1_row2,table1_row3,...,...,...,)
FROM db2.table_2 (table2_row1,table2_row2,table2_row3,...,...,...,)
I hope this haven't been very confusing, I'll appreciate any kind of help that
you may provide me. Thousands of thanks in advance.
Greetings.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-09-21 21:56:58 | Re: Best way to create a sequence generator at run time? |
| Previous Message | Mladen Gogala | 2010-09-21 18:16:28 | Pgstatspack and pgfouine with auto_explain? |