DT

Drizzle Team•16mo ago•

3 replies

UrosHCS

Postgres tables with same name but different schema

I have three

users

users

tables, each in different postgres schema. They have 3 columns in common: email, createdAt and updatedAt. When I try to make a relational query where I fetch a token with the user relation, the type of the user contains just those 3 columns, instead of all columns of that specific users table (image attached). Seems like it is an intersection of the types of those 3 users. Seems like the problem is that a relation is defined as:

Relations<"users", {
  ...
}>

Relations<"users", {
  ...
}>

meaning that a relation does not take into consideration the schema. Is there a way to get around this?