Re: dbLink Query

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Richard C <richardalancock(at)yahoo(dot)co(dot)uk>
Cc: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: dbLink Query
Date: 2006-03-10 13:12:06
Message-ID: 44117B26.1070300@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, Richard,

Richard C wrote:

> How do I install or setup the function dbLink so that I can use this
> feature.

In your PostgreSQL installation, there should be a contrib directory,
that contains a file dblink.sql - execute it via psql against your
database, and it installs the function definitions.

On my debian machine, it is under:
/usr/share/postgresql/7.4/contrib/dblink.sql
/usr/share/postgresql/8.1/contrib/dblink.sql

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Fay Du 2006-03-10 13:24:44 How can I selet rows which have 2 columns values cross equal?
Previous Message Markus Schaber 2006-03-10 13:09:57 Re: pg reserved words