postgresql - how to pass an image as paramenter to sql function -

I am a quality analyzer and I have got the task of testing a database function n_execute () which takes 3 parameters 1. image_name 2 image_data (byte array) This is a blob type. 3. DataCredited Now my problem is that I want to call this function to test this function, but I do not know how to implement the second parameter of this function. I know that we can do this by writing some Java code that calls this function, but I want to execute it only via SQL Editor.

You have not mentioned the database platform that you did not work on, but SQL Server T / SQL The script will have one in the data. A simple example would be 0x0102030405 which represents 5 hex bytes; 01, 02, 03, 04 and 05.

Edit for PostgreSQL

Take a look at the document for PostgreSQL. Note:

Biotechnology supports two external formats for input and output: The historical "Escape" format of PostgreSQL and the "HEX" format.

The PostGrace SQL will be equivalent to my SQL Server example E '\\ x0102030405' .