암호화후 복호화 하기 split_part사용

create extension pgcrypto; select encode(encrypt(convert_to('홍길동','utf8'),'ENC_KEY2','aes'),'hex'); select convert_from(decrypt(decode('eca7e7bfbcd093229fb08e80fb0ee27f8368409e6acd8566c9c160766f897291d8f105397cf8410af16864f4099584cb','hex'),'ENC_KEY2','aes'),'utf8') as decrypt_id; select lgn_id, pswd, to_char(now(),'yyyymmddHH24MISS') as dt, encode(encrypt(convert_to( 'user_id#' || lgn_id || '#e..

원문링크 : 암호화후 복호화 하기 split_part사용