Below is the stored procedure I have written:
CREATE OR REPLACE FUNCTION GetAllEmployee()
RETURNS setof "Employees" AS
$BODY$
BEGIN
RETURN QUERY
select * from "Employees";
END;
$BODY$
LANGUAGE plpgsql;
I am attempting to execute this stored procedure from my route with the following code:
sequelize.sync().then(function() {
app.get("/sp", (req, res) => {
try {
sequelize.query("GetAllEmployee()").then(function(data) {
console.log(data);
});
} catch (error) {
console.log(error);
}
});
});
However, I continue to encounter an error message that says:
Unhandled rejection SequelizeDatabaseError: syntax error at or near "GetAllEmployee"