Home / Questions / 129972
Accepted
Johnny Pachecp
Asked: 2020-01-10 14:30:32 +0800 CST 2020-01-10 14:30:32 +0800 CST

How to make a stored procedure in postgresql for login?

  • 772

This is my db model in terms of users This is my db model in terms of users

It turns out that I need the user to be able to log in with the same credentials, the intention is to create a procedure where the server returns its user data, and the teacher and administrative data if it is, the dilemma is that a user can be a teacher in several institutions, or administrative in several, or be a teacher and administrative in different institutions. What would be your solution? What language would the procedure be in? It doesn't matter what type of data it returns, as long as it can be used on the server.

postgresql

1 Answers

  1. Best Answer

    You should use two query

    1. A query for authentication
    2. A query to select the institution (authorization)
    • 1