Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Create user mapping

Store remote authentication details for one local role.

Back to sheetBrowse commands
Sign in to save
Section: Foreign Data Wrappers and Cross-DB Access

Create user mapping

sql
sql
CREATE USER MAPPING FOR appuser
SERVER analytics_remote
OPTIONS (user 'analytics_user', password 'secret');
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Foreign Data Wrappers and Cross-DB Access
Enable postgres_fdw
Install the built-in foreign data wrapper for PostgreSQL servers.
OpenIn sheetsqlsame section
Create foreign server
Define a remote PostgreSQL server.
OpenIn sheetsqlsame section
Import foreign schema
Bring remote tables into a local schema automatically.
OpenIn sheetsqlsame section
Create foreign table manually
Define a foreign table manually.
OpenIn sheetsqlsame section
Drop foreign server
Remove the foreign server and dependent objects.
OpenIn sheetsqlsame section
Show wal_level
Inspect the current WAL level setting.
OpenIn sheetsql