Tried to do a "use database" within postgres.
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.
