_Pear
Explore posts from serversDTDrizzle Team
•Created by _Pear on 3/3/2024 in #help
Is it possible to store an array of primary keys for table A on table B using Postgres?
IThis might be more of a Postgres question ,and my research has turned up that the answer is pretty much "No", but I was wondering if anybody has found a way to do this using Drizzle and custom types maybe?
I want to store an array of primary keys in a table. I'm having trouble figuring out the correct way to do this.
I would settle for using the a
json type as well but that doesn't seem to work either given the type in the column of the reference table needs to be the same as the primary key, in this case uuid or text.
Any ideas? Thanks!7 replies