upload multiple image as binary array

[npltr62]

I want upload not one image but multiple image from select input, in order to have a row with bytea array column.

<input type="file" id="fileInput" multiple> 

const fileInput = document.getElementById("fileInput");

const files = fileInput.files;

 const headers = {
            'Content-Profile': 'srv_tech',
            'Content-Type': 'application/octet-stream',
          };
          const response = await this.$axios.post('rpc/upload_binary', files, { headers });

[steve-chavez]

If you have a function with a single bytea unnamed parameter, that would work. See https://postgrest.org/en/stable/references/api/stored_procedures.html#functions-with-a-single-unnamed-parameter.

[npltr62]

I have a function with a single bytea[] unnamed parameter but it seems that's not recongnizing by api

CREATE OR REPLACE FUNCTION srv_tech.upload_b(bytea[])
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
DECLARE
   id integer;
BEGIN
    INSERT INTO srv_tech.form_results(files) values ($1)
    RETURNING form_results.id
    INTO id;
    RETURN id;
END;
$function$
;

[steve-chavez]

Try making it non-array.

[npltr62]

Try making it non-array.

i tried it and it was ok but with an array it's not working ...

[steve-chavez]

Yeah array will not work - bytea is an unknown binary input, the server cannot know how to separate different bytea values.