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.
Erwin PombettAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
earth man2Connect With a Mentor Commented:
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
 
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

SEE THE WINNERS
 
earth man2Commented:
0
 
Erwin PombettAuthor 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
 
Erwin PombettAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.