Okay suppose I have a user table in my postgres dp(database name) which has some fields like Name and Id. Now I want to query my database using raw query.
So to do that what I did is I created a function
def get_by_name(name) do
query = """
SELECT * FROM user WHERE name ILIKE '$1#%'
"""
Ecto.Adapters.SQL.query!(Wizex.Repo, query, [name])
end
Now suppose I have saved the name “rockstar” in the user table. Now when I call this function it should get me this name.
Also why can’t you query sql raw queries in postgres?
Postgres is a database right? But internally it uses sql only.
