Cross Schema linking / relationships. #15303
-
|
I may be losing my mind, but I can't seem to determine how to create a relationship between 2 tables in different schemas in the same database. For this instance, I have entity.entity table with a source_id column that references a table called source.source (same column name) in a postgres DB. The FK is defined within PG. I have both schemas imported into the same app in Budibase, but I'm unable to create a relationship between these tables. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
Hi @theDonM - this is something that is not currently supported - relationships can only exist within a single schema today in Budibase. You might be able to use a query to access a different schema in the table - but cross-schema data is not something that Budibase supports fully today. |
Beta Was this translation helpful? Give feedback.
-
|
Thang for the info! |
Beta Was this translation helpful? Give feedback.
Hi @theDonM - this is something that is not currently supported - relationships can only exist within a single schema today in Budibase. You might be able to use a query to access a different schema in the table - but cross-schema data is not something that Budibase supports fully today.