postgresql - Postgres/hstore : how to get IDs of rows with certain key in their hstore field?

Question

我正在查询 pgsql 数据库以查找在 hstore 字段中具有特定键的行:

select DISTINCT
from (select id, exist(data, ‘exercise_quiz’) key_exists
  from user_tracking) x
where key_exists = true;

它工作正常，但我需要打印它返回的相应行的 ID。我可以使用此命令执行此操作吗？

Answer 1

使用运算符 hstore ?文本 (does hstore contain key?) :

select id
from user_tracking
where data ? 'exercise_quiz';