FDW (Foreign Data Wrappers) are very useful, and I need them to read CSV files. (Please do not reply to say “use COPY”). Generally using it on other machines is “plug and play”… But on my Windows laptop I try the following commands and it fails:
<code>postgres=# CREATE EXTENSION postgres_fdw;
CREATE EXTENSION
postgres=# CREATE SERVER fdw_files FOREIGN DATA WRAPPER file_fdw;
ERROR: foreign-data wrapper "file_fdw" does not exist
</code>
<code>postgres=# CREATE EXTENSION postgres_fdw;
CREATE EXTENSION
postgres=# CREATE SERVER fdw_files FOREIGN DATA WRAPPER file_fdw;
ERROR: foreign-data wrapper "file_fdw" does not exist
</code>
postgres=# CREATE EXTENSION postgres_fdw;
CREATE EXTENSION
postgres=# CREATE SERVER fdw_files FOREIGN DATA WRAPPER file_fdw;
ERROR: foreign-data wrapper "file_fdw" does not exist
It seems that I have all permissions to use the extension, but Google says nothing about error “file_fdw does not exist”.
I am expectig that the standard the CREATE commands-sequence is acceptd, as in this example.
Notes
<code>postgres=# dew
List of foreign-data wrappers
Name | Owner | Handler | Validator
--------------+----------+----------------------+------------------------
postgres_fdw | postgres | postgres_fdw_handler | postgres_fdw_validator
(1 row)
postgres=# select version();
version
------------------------------------------------------------
PostgreSQL 14.1, compiled by Visual C++ build 1914, 64-bit
(1 row)
</code>
<code>postgres=# dew
List of foreign-data wrappers
Name | Owner | Handler | Validator
--------------+----------+----------------------+------------------------
postgres_fdw | postgres | postgres_fdw_handler | postgres_fdw_validator
(1 row)
postgres=# select version();
version
------------------------------------------------------------
PostgreSQL 14.1, compiled by Visual C++ build 1914, 64-bit
(1 row)
</code>
postgres=# dew
List of foreign-data wrappers
Name | Owner | Handler | Validator
--------------+----------+----------------------+------------------------
postgres_fdw | postgres | postgres_fdw_handler | postgres_fdw_validator
(1 row)
postgres=# select version();
version
------------------------------------------------------------
PostgreSQL 14.1, compiled by Visual C++ build 1914, 64-bit
(1 row)
These questions are similar but has no answer:
-
I am running “statements in the same database”, /a/61320525/24857883
-
This answer say to check the Wiki, but the wiki say that “CSV File Wrapper is native”, https://wiki.postgresql.org/wiki/Foreign_data_wrappers#File_Wrappers