troubleshooting Question

How to add postgresql 9.2 extensions in windows seven ?

Avatar of Erwin Pombett
Erwin PombettFlag for Switzerland asked on
PostgreSQL
6 Comments1 Solution3115 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros