Solved

How to add postgresql 9.2 extensions in windows seven ?

Posted on 2012-12-20
6
2,258 Views
Last Modified: 2013-01-14
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
Comment
Question by:toshi_
  • 4
  • 2
6 Comments
 
LVL 22

Expert Comment

by:earth man2
ID: 38711175
My dblink.sql is in C:\Program Files\PostgreSQL\9.0\share\contrib
0
 
LVL 22

Expert Comment

by:earth man2
ID: 38711588
http://www.postgresql.org/docs/9.2/static/dblink.html
it interfaces directly with library dblink.dll
0
 
LVL 22

Expert Comment

by:earth man2
ID: 38714652
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:toshi_
ID: 38723125
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
 
LVL 22

Accepted Solution

by:
earth man2 earned 300 total points
ID: 38725745
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
 

Author Closing Comment

by:toshi_
ID: 38774195
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now