CREATE_SERVER(7pg17)

✨ CREATE_SERVER ✨

okay so bestie, welcome to CREATE_SERVER(7) from the PostgreSQL 17.11 Documentation. It’s giving “define a new foreign server” main character energy, and we’re gonna cover every single detail. 🫶💅

🌸 NAME 🌸

CREATE_SERVER — define a new foreign server. periodt. 💖

✨ SYNOPSIS ✨

CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]
    FOREIGN DATA WRAPPER fdw_name
    [ OPTIONS ( option 'value' [, ... ] ) ]

this is the whole shape of the command — no cap, that’s the synopsis. ✨

💖 DESCRIPTION 💖

CREATE SERVER defines a new foreign server. The user who defines the server becomes its owner. slay, ownership acquired. 👑

A foreign server typically encapsulates connection information that a foreign-data wrapper uses to access an external data resource. Additional user-specific connection information may be specified by means of user mappings. iykyk — user mappings are a whole vibe. 🦋

The server name must be unique within the database. no cap, no duplicate server names, bestie. 💅

Creating a server requires USAGE privilege on the foreign-data wrapper being used. That’s the vibe check: no USAGE, no server creation. 😭

🎀 PARAMETERS 🎀

• IF NOT EXISTS — do not throw an error if a server with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing server is anything like the one that would have been created. literally, it might be a totally different vibe. 🙈
• server_name — the name of the foreign server to be created. iconic. ⭐
• server_type — optional server type, potentially useful to foreign-data wrappers. 🦋
• server_version — optional server version, potentially useful to foreign-data wrappers. 🦋
• fdw_name — the name of the foreign-data wrapper that manages the server. it’s giving manager energy. 👑
• OPTIONS ( option 'value' [, ... ] ) — this clause specifies the options for the server. The options typically define the connection details of the server, but the actual names and values are dependent on the server’s foreign-data wrapper. 🌸

🦋 NOTES 🦋

When using the dblink module, a foreign server’s name can be used as an argument of the dblink_connect(3) function to indicate the connection parameters. It is necessary to have the USAGE privilege on the foreign server to be able to use it in this way. periodt. 💫

If the foreign server supports sort pushdown, it is necessary for it to have the same sort ordering as the local server. fr fr. 🍓

🌈 EXAMPLES 🌈

Create a server myserver that uses the foreign-data wrapper postgres_fdw:

CREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', dbname 'foodb', port '5432');

See postgres_fdw for more details. obsessed. ✨

⭐ COMPATIBILITY ⭐

CREATE SERVER conforms to ISO/IEC 9075-9 (SQL/MED). periodt. 💅

👑 SEE ALSO 👑

• ALTER SERVER (ALTER_SERVER(7))
• DROP SERVER (DROP_SERVER(7))
• CREATE FOREIGN DATA WRAPPER (CREATE_FOREIGN_DATA_WRAPPER(7))
• CREATE FOREIGN TABLE (CREATE_FOREIGN_TABLE(7))
• CREATE USER MAPPING (CREATE_USER_MAPPING(7))

---

mwah 💋 — this page is from PostgreSQL 17.11, dated 2026, and its manual name is CREATE SERVER(7). go be the main character of your own foreign server, bestie. 🫶✨