How to execute SQL SELECT query in migrations

I think the issue is that you are quoting t2.tenants in the SELECT statement. I think it should be:

execute("SELECT MAX(id) from t2.tenants")

no, it’s correct. already tried.

I’ll respond here too, on top of slack. Also I’m assuming postgres.

@kip is correct, "t2.tenants" is not the same as t2.tenants. However if you really want to quote it, you have to quote the schema and the table separately, "t2"."tenants".

You can test it easily in psql.

create table asd ();
select * from asd;
select * from "asd";
select * from public.asd;
select * from "public"."asd";
select * from "public.asd";

CREATE TABLE
SELECT 0
SELECT 0
SELECT 0
SELECT 0
ERROR:  relation "public.asd" does not exist
LINE 5: select * from "public.asd";

Why do you wrap SELECT query in parens? Also I believe that @kip is right, and "t2.tenants" mean select table default."t2.tenants" where you wanted to select from t2.tenants which would be "t2"."tenants".

Thank you jola. you are right. have seen your answer on slack as well.

thank you.