PostgreSQL - Advanced Features
Which PostgreSQL command is used to install the extension for the built-in foreign data wrapper to connect to other PostgreSQL servers?
Which PostgreSQL command is used to install the extension for the built-in foreign data wrapper to connect to other PostgreSQL servers?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Recall extension installation syntax
PostgreSQL uses CREATE EXTENSION to add extensions.Step 2: Match correct command for postgres_fdw
The correct command is CREATE EXTENSION postgres_fdw; to enable FDW support.Final Answer:
CREATE EXTENSION postgres_fdw; -> Option BQuick Check:
Extension install = CREATE EXTENSION [OK]
Quick Trick: Use CREATE EXTENSION to add FDW support [OK]
Common Mistakes:
- Using INSTALL or ADD instead of CREATE EXTENSION
- Confusing ENABLE with CREATE EXTENSION
- Missing semicolon at command end
Master "Advanced Features" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes