Materials for testing the extensions:

sqlite_fdw extension

The file "test.db" is a database created with SQLite as follows:

$ sqlite3.exe "test.db"

SQLite version 3.8.1 2013-10-17 12:57:35
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table tbl1(one varchar(10), two smallint);
sqlite> insert into tbl1 values('hello!',10);
sqlite> insert into tbl1 values('goodbye', 20);
sqlite> select * from tbl1;
hello!|10
goodbye|20
sqlite>

Then a sqlite server can be created as follows:

CREATE SERVER sqlite_server
  FOREIGN DATA WRAPPER sqlite_fdw
  OPTIONS (database 'D:\postgresql-test-extxtensions\test.db'); /* adapt to your config. */

Note: If you don't have compiled the sqlite command-line shell "sqlite3.exe" by your-self, it can be found on the SQLite Official Web Site, here.

www_fdw extension

The file "./curl/curl-ca-bundle.crt" is a possible certificate (one of those provided with libcurl).

It is necessary to pass a certificate to the www_fdw server at creation via the cainfo" option:

CREATE SERVER www_fdw_google_search_server FOREIGN DATA WRAPPER www_fdw 
    OPTIONS (
        uri 'https://ajax.googleapis.com/ajax/services/search/web?v=1.0',
        cainfo 'C:\mingw32\msys\local\share\curl\curl-ca-bundle.crt'
        );
/* Adapt "cainfo" option to your config. The path MUST be written the Windows way */

Note: The directory "./sql/" contains all the necessary SQL commands to create and test each one of the servers.