Read the doco which said to use dblink. However this produced the following error: "No function matches the given name and argument types. You might need to add explicit type casts."
So installed apt-get install postgresql-contrib-8.3
But it still didnt work. Read some more: find /usr/share/postgresql -name dblink.sql (/usr/share/postgresql/ 8.3/contrib/dblink.sql) cd /usr/share/postgresql/8.3/contrib psql -d database -f dblink.sql
psql database SELECT * FROM dblink('dbname=database', 'select name, title from pages') AS t1(name text, title text);
And hey presto it works... and it only took 3 hours.