Which of the following is the correct SQL command to create a foreign server named myserver using the postgres_fdw wrapper?

easy📝 Syntax Q12 of 15

PostgreSQL - Advanced Features

Which of the following is the correct SQL command to create a foreign server named myserver using the postgres_fdw wrapper?

ACREATE FOREIGN SERVER myserver FOREIGN DATA WRAPPER postgres_fdw;

BCREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw;

CCREATE SERVER myserver USING FOREIGN DATA WRAPPER postgres_fdw;

DCREATE FOREIGN SERVER myserver USING postgres_fdw;

Step-by-Step Solution

Solution:

Step 1: Recall correct syntax for creating foreign server
The correct syntax is: CREATE FOREIGN SERVER server_name FOREIGN DATA WRAPPER wrapper_name;
Step 2: Match options to syntax
CREATE FOREIGN SERVER myserver FOREIGN DATA WRAPPER postgres_fdw; matches exactly. Options A and C miss the FOREIGN keyword before SERVER. CREATE FOREIGN SERVER myserver USING postgres_fdw; uses USING incorrectly.
Final Answer:
CREATE FOREIGN SERVER myserver FOREIGN DATA WRAPPER postgres_fdw; -> Option A
Quick Check:
CREATE FOREIGN SERVER ... FOREIGN DATA WRAPPER ... [OK]

Quick Trick: Use CREATE FOREIGN SERVER ... FOREIGN DATA WRAPPER ... [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free