Actually, I've just re-read this. Did you run the script at https://github.com/turbo/pg-shortkey/blob/master/pg-shortkey.sql (that's the source of the shortkey type)? It only requires the pg-crypto extension, which is already installed in Supabase
(Reply in the thread so we can avoid cluttering up the main chat)
a
asleepingpanda
03/03/2022, 5:45 PM
Oh my gosh.. I'm so sorry! When I saw that they said to run a script, I didn't realize that it was a local script on the GitHub page. I thought it was like a script that comes with an extension. I'm so sorry! Thank you for the clarification. I'm gonna try that out now
s
Scott P
03/03/2022, 5:46 PM
Yeah, I thought it was a separate extension that needed to be installed because the link doesn't advise that you need to do anything other than run the script for usage
a
asleepingpanda
03/03/2022, 5:47 PM
Wow you're a life saver! That worked out perfect
asleepingpanda
03/03/2022, 5:47 PM
Now, reading through this, would you advise using the shortcode as a field on my table that's NOT the primary key?
s
Scott P
03/03/2022, 5:48 PM
I think you could use it either as a pk since they're unique, or just as a non-pk field
a
asleepingpanda
03/03/2022, 5:48 PM
Ok great. Thanks again! Really appreciate the help