How to add postgresql 9.2 extensions in windows seven ?

Erwin Pombett
Erwin Pombett used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
earth man2

Commented:
My dblink.sql is in C:\Program Files\PostgreSQL\9.0\share\contrib
earth man2

Commented:
http://www.postgresql.org/docs/9.2/static/dblink.html
it interfaces directly with library dblink.dll
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Start Today!
Erwin Pombett

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
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.
Erwin Pombett

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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial