Erwin Pombett
asked on
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.
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
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
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.
My dblink.sql is in C:\Program Files\PostgreSQL\9.0\share \contrib
http://www.postgresql.org/docs/9.2/static/dblink.html
it interfaces directly with library dblink.dll
it interfaces directly with library dblink.dll
ASKER
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
...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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.