postgresqlforeign-data-wrapperpostgresql-extensions

error while creating Postgres extension www_fdw


I want to use www_fdw extension of PostgreSQL in order to read data from web services. I used this command to create extension:

CREATE EXTENSION IF NOT EXISTS www_fdw CASCADE

but it gives me following error:

could not open extension control file "C:/Program Files (x86)/PostgreSQL/9.6/share/extension/www_fdw.control": No such file or directory

I am working in Windows.

Any idea whats the reason for error?


Solution

  • The problem was solved when I installed mingw64 and msys. I compiled postgresql server in my machine and I used the:

    build packages for www_fdw:

    http://www.postgresonline.com/journal/archives/361-Foreign-Data-Wrappers-for-PostgreSQL-9.5-windows.html

    and copied the related folders in the related directories (bin, lib, share) in postgresql folder.

    Thanks a-horse-with-no-name!