Sample Header Ad - 728x90

Rely on .pgpass in CREATE USER MAPPING

5 votes
1 answer
3094 views
I am trying to create a script which creates a postgres-fdw connection between two postgres 9.4 databases. The script (which is checked in under version control), has been relying on pgpass to do other things. Is there any option I can use to request that the password be looked up in pgpass? ... in general, where is the documentation on what options are available for CREATE USER MAPPING? the reference just says that options depend on the server.
Asked by shaunc (151 rep)
Jan 28, 2015, 03:04 AM
Last activity: Aug 21, 2023, 03:18 PM