Postgres tables with same name but different schema
I have three
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:
meaning that a relation does not take into consideration the schema. Is there a way to get around this?
2 Replies