patrickReiis on Nostr: Try logging into your postgres shell, then do: SELECT * FROM nostr_events WHERE kind ...

Try logging into your postgres shell, then do:

SELECT * FROM nostr_events
WHERE kind = 30383
AND tags_index @> '{"n": ["rejected"]}';


Or to see the granted ones:

SELECT * FROM nostr_events
WHERE kind = 30383
AND tags_index @> '{"n": ["approved"]}';