I have user information in a table that I want to use to add users to the user roles tables that are part of postgresql. My question is this: the passwords in my user table are in there as a text file with the data being encrypted using the crypt function, is there a way I can use this crypt password when I do a “CREATE ROLE userid LOGIN PASSWORD 'crypt password' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE” I know that in the current CREATE ROLE I have listed will take a clear text password and encrypt it for me. What do I need to change to use an encrypted password?
