Re: installing dblink

On Fri, Jun 4, 2010 at 9:04 AM, Luiz Eduardo Cantanhede Neri <lecneri@gmail.com> wrote:

On psql you may try \c <database name> [username]

On Tue, May 18, 2010 at 10:43 PM, Oni <drentha@gmail.com> wrote:

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.



--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice