foreign-data wrapper “…” does not support IMPORT FOREIGN SCHEMA

Symptoms

A statement failed with SQLSTATE HV00P (fdw_no_schemas), reported at severity ERROR. This is a Foreign Data Wrapper Error (SQL/MED) condition: PostgreSQL emits the message foreign-data wrapper "…" does not support IMPORT FOREIGN SCHEMA.

• The client receives SQLSTATE HV00P (fdw no schemas).
• The operation is rejected at ERROR level; the statement does not complete.

What the server log shows

ERROR:  foreign-data wrapper "…" does not support IMPORT FOREIGN SCHEMA

Why PostgreSQL raises this

PostgreSQL raises this error from the area indicated by its SQLSTATE class. The condition name pinpoints the specific rule that was violated.

As described in PostgreSQL’s Appendix A PostgreSQL Error Codes, SQLSTATE HV00P carries the condition name fdw_no_schemas in class Foreign Data Wrapper Error (SQL/MED). (Paraphrased — see the linked reference for the exact wording.)

Common causes

• The operation violated the rule named by this SQLSTATE condition.
• An input, object, or state did not satisfy a precondition.

How to fix it

1. Use the SQLSTATE condition name to identify the exact rule.
2. Correct the offending input, object, or state and retry.
3. See the linked full SQLSTATE reference for detailed guidance.

Version applicability

This message is present in PostgreSQL 15, 16, 17, 18 and 19.

Related & next steps

• SQLSTATE HV00P — Fdw No Schemas (full reference)
• PostgreSQL error code index

Reference: PostgreSQL Appendix A PostgreSQL Error Codes.