I have a DB table that someone else created, its PK is a single column of type 'uuid'. I'm struggling to perform a simple select by that column. Examples I have tried with no success:
select from site where id = "9d4da323-4c20-360f-bd9b-ec54feec54f0"
select from site where id = UUID('9d4da323-4c20-360f-bd9b-ec54feec54f0')
select from site where id::text = '9d4da323-4c20-360f-bd9b-ec54feec54f0'
what's the right syntax?