Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2611
  • Last Modified:

How to add postgresql 9.2 extensions in windows seven ?

Hello experts,

my goal is : i'd like to use dblink_connect() function,

--- situation ---- -
i have an installation of pgsql 9.2 on my seven computer.

i've google and i 'm supposed to have packages in
C:\Program Files\PostgreSQL\9.2\share\contrib\
but my folder is empty.

after installing the package - which is easy on a linux distrib : apt-get install ...-
i'm supposed to apply the dblink.sql file on the database i'd like to use dblink_connect() in.

question:
is it normal to find the file dblink--1.0.sql in
C:\Program Files\PostgreSQL\9.2\share\extension ?

i'm confused,
can someone help me to figure this out ?

is it normal not to have extensions in contrib ? is the file dblink--1.0.sql the package ?
......
i badly need an explanation ;)

thank you in advance for all your help.
0
toshi_
Asked:
toshi_
  • 4
  • 2
1 Solution
 
earth man2Commented:
My dblink.sql is in C:\Program Files\PostgreSQL\9.0\share\contrib
0
 
earth man2Commented:
http://www.postgresql.org/docs/9.2/static/dblink.html
it interfaces directly with library dblink.dll
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
toshi_Author Commented:
hello earthman,
...i feel like a small boy when you gave me links like the last you gave me...
i'm  not able to read the c code for dblink you gave me... .i dont really know where to start with in order to have an answer to my question.

i dont know how to deal with the help on this thread, makes me thing you honour me as if i was an expert of your level ;)

so far i understand that my windows postgrres install - i did not change a single thing from the default install - is not the same than yours. Did you change when installing ?

what should i understant with the link to dblink.sql ?

toshi
0
 
earth man2Commented:
If your distribution has a script dblink.sql and library dblink.dll then running the script dblink.sql using psql.exe or PgAdmin should install the required stored functions.
0
 
toshi_Author Commented:
ritght on,

my script was in share/extension,
after importing the file with psql i can see a new Extension - with Pgadmin - in my db. So far i had only plpgsql, now i have both: plpgsql and dblink.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now