Custom Function for Encryption

Avatar

Avatar

asariaaara

Avatar

asariaaara

asariaaara

22-03-2019

Hey Geeks,

I made a custom function which encrypts the data using encrypt Postgresql Function.

The code goes like:

<funcList name="myList" namespace="cus">

      <group name="string" label="String">

        <function name="EncryptString" type="string" args="(&lt;String&gt;)" help="Encrypts given String with AES using hugyourclient"

                  minArgs="1" maxArgs="1" display="Encrypts given String with AES using hugyourclient">

          <providerPart provider="PostgreSQL" body="ENCRYPT(($1),'hugyourclient','aes')"/>

        </function>

      </group>

    </funcList>

However this gives me following error:

1716845_pastedImage_1.png

Am I doing any mistake.

or is there any other way of implementation.

Regards.

View Entire Topic

Avatar

Avatar

asariaaara

Avatar

asariaaara

asariaaara

26-03-2019

Hi Parvesh,

Thanks for your help.

However this extension pgcrypto is already installed.

Regards