I am using the built-in Postgresql database using the Retool interface, and I need to create a unique constraint on multiple fields in a table. Is this possible?
Hey @hodge! Yes, this is possible with tables using RetoolDB.
Create a table with the multi-column unique constraint:
Individual columns are not required to be unique:
But attempting to insert the same value into both columns should fail:
Let me know if you have any other questions!