Problem with encode() function
От | Glenn_Wiens@via-christi.org |
---|---|
Тема | Problem with encode() function |
Дата | |
Msg-id | OF31D5CA48.78E79003-ON86256E9B.006CB5CC-86256E9B.006CFF72@via-christi.org обсуждение исходный текст |
Ответы |
Re: Problem with encode() function
|
Список | pgsql-novice |
I have a table where I have stored plain text passwords in a varchar field. I would like to convert these to an encoded field. I have been able to insert values into a test table using this syntax with a literal password: insert into testtable (name, password) values ('glenn',encode ('mypassword','base64')); and I can read them back out with the decode(password,'base64') syntax. This is the behavior I want. But when I try to encode data from an existing table: create table newtable as select name, encode(password,'base64') as password from oldtable; I get this error ERROR: Function encode(character varying, "unknown") does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts I have tried the following casts password::text case(password as text) but I still get the error: ERROR: Function encode(text, "unknown") does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts Is there a way I can accomplish this task? Thanks.
В списке pgsql-novice по дате отправления: