CREATE_SERVER(7pg13)

✨ CREATE SERVER 💅 (PostgreSQL 13.23, CREATE_SERVER(7))

okay bestie, so you want to make a whole new foreign server?? iconic. let's get into it 🫶

---

🌸 SYNOPSIS 🌸

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

like, that's the whole vibe. read it, love it, respect it ✨

---

💖 DESCRIPTION 💖

CREATE SERVER defines a new foreign server. and the way that whoever creates it just Literally becomes its owner?? main character energy fr fr 👑

so basically, a foreign server is this lil package of connection info that a foreign-data wrapper uses to go talk to some external data resource. you can also add your own extra user-specific connection deets through user mappings — very demure, very customizable 🎀

the server name has to be unique within the database. no dupes, no copies, no twinsies. periodt 💅

⚠️ also important bestie: creating a server requires USAGE privilege on the foreign-data wrapper you're using. no privilege, no server. that's just the rules 😭

---

🌈 PARAMETERS 🌈

• IF NOT EXISTS — don't throw an error if a server with the same name already exists, just issue a notice instead 💌 but real talk: there's no guarantee the existing server is anything like the one you were about to create. so like... eyes open, bestie 🙈
• server_name — the name of the foreign server you're creating. pick something cute ✨
• server_type — optional server type, potentially useful to foreign-data wrappers. lowkey optional, highkey helpful 🦋
• server_version — optional server version, potentially useful to foreign-data wrappers. same vibe, different field 🌸
• fdw_name — the name of the foreign-data wrapper that manages the server. the boss of the operation, if you will 👑
• OPTIONS ( option 'value' [, ... ] ) — this clause specifies the options for the server. typically these define the connection details of the server, but the actual names and values are dependent on the server's foreign-data wrapper — so check with your fdw, not with me 🫶

---

🦋 NOTES 🦋

okay so when you're 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. cute, right? BUT — it is necessary to have the USAGE privilege on the foreign server to be able to use it in this way. no privilege, no dblink. sorry babes 💀

and if the foreign server supports sort pushdown, it is necessary for it to have the same sort ordering as the local server. like, they have to match. matching outfits only 🔥

---

🍓 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. she ate, no crumbs 💅

---

⭐ COMPATIBILITY ⭐

CREATE SERVER conforms to ISO/IEC 9075-9 (SQL/MED). standards girlie behavior, we love to see it 💖

---

🎀 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))

---

that's the whole page bestie, go forth and create servers responsibly 🧚💜

signing off from PostgreSQL 13.23, dated 2025 — mwah, talk soon 💋