Postgresql

[subalan]

Hi,

I want to select data from one database and insert the same into another database using same query. Both the databases have same set of table structure. How to do this in PostgreSQL?

[russell]

INSERT INTO TableA
SELECT * FROM TableB

http://www.postgresql.org/docs/8.0/i...ql-insert.html