image

create.sql

CREATE TABLE  IF NOT EXISTS media_file(
	id SERIAL PRIMARY KEY,
	img BYTEA,
	mimetype VARCHAR(15),
	media INT REFERENCES media(id) ON DELETE CASCADE
);

media.controller.js

exports.addFile = async(req, res) => {
    let sql = 'INSERT INTO media_file(media, mimetype, img) VALUES ($1, $2, $3) returning *';
    try {
      const result = await postgres.client.query(sql, [req.body.media, req.file.mimetype, req.file.buffer]);
      res.status(201).json(result.rows[0]);
      res.end();
    } catch (err) {
      return res.status(500).json({ errors: [{ param: undefined, msg: err.detail, value: undefined }] });
    }
  };