Re: Postgres_fdw- User Mapping with md5-hashed password

On 4/8/25 13:00, Dirschel, Steve wrote: I know I can create user steve_test with password testpassword122 as md5 by doing: select 'md5'||md5('testpassword122steve_test'); Returns --> md5eb7e220574bf85096ee99370ad67cbd3 CREATE USER steve_test WITH PASSWORD 'md5eb7e220574bf85096ee99370ad67cbd

Postgres_fdw- User Mapping with md5-hashed password

I know I can create user steve_test with password testpassword122 as md5 by doing: select 'md5'||md5('testpassword122steve_test'); Returns --> md5eb7e220574bf85096ee99370ad67cbd3 CREATE USER steve_test WITH PASSWORD 'md5eb7e220574bf85096ee99370ad67cbd3'; And then I can login as steve_test wi