Thread: installing dblink
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.
On psql you may try \c <database name> [username]
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