Lutz Broedel <lb@xxxxxxxxxxxxxxxxxxxx> writes: > ERROR: Error »syntax error« at »$1« at character 13 > QUERY: ALTER ROLE $1 WITH ENCRYPTED PASSWORD $2 > > I have tried this in several ways and it seems, ALTER ROLE just does > not accept a parameter instead of name. Does anybody have a solution > for this? You probably need to build the query dynamically and use EXECUTE. -Doug
