|
Hi, I am new to PostgreSQL. I am using PostgreSQL 8.4. [Requirement]: I want to move all the records from a table in a database say,
‘db_one’ into a table in another database say, ‘db_two’.
This I need to do by executing a stored function that I stored in the ‘postgres’
database. How can I effectively do this? [Additional information] 1.
‘db_one’ and ‘db_two’ are
present in the same server (under localhost:5432 ) as that of the ‘postgres’
database. 2.
Table in both the databases db_one & db_two are identical
(i.e. has same number of columns, column name, type etc.). Here’s what I tried to do, select
dblink_connect('connection_to_db_one', 'host=localhost port=5432 user=postgres
dbname=db_one password=*****'); select
dblink_connect('connection_to_db_two', 'host=localhost port=5432 user=postgres
dbname=db_two password=*******'); select * from
dblink('connection_to_db_one','select * from db_one_table') as
temp_table(user_id integer, "MinTimestamp"
timestamp without time zone, "MaxTimestamp" timestamp without time
zone); PERFORM
dblink_exec('connection_to_db_two','insert into db_two_table(temp_table)'); select
dblink_disconnect('connection_to_db_one'); select
dblink_disconnect('connection_to_db_two'); I attempted the above code snippet from inside a stored function
and happened to receive the following error: ERROR: query has no
destination for result data Kindly provide any help/suggestions. Thanks
& Regards, Vishnu S This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message. |
