Problems copying data to different database - Mailing list pgsql-general

Hi,

My requirement is to archive records from main DB to the archive DB after certain period. Using Dblink facility, I'm
ableto perform any kind of activity on the archive DB, except copying from Table of MainDb to a Table of ArchiveDb. Is
itpossible to move the selective records using following kind of query: 

select dblink_exec ('dbname = ArchiveDb', 'insert into Archive_Table select * from To_Be_Archived_Table')

Request your suggestions to achieve this.

Thanks,
RamaKrishna.