How to execute SQL SELECT query in migrations

Questions & Help Questions
, ,
4

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";