List keys in Amazon SimpleDB

Question

I am trying to list keys in Amazon SimpleDB. In SQL, it will be something like this:

select unique itemName() from domain;

I searched, but did not find a way to do this. Any help?

Answer 1

By definition, elements in a domain are unique, so you were almost there:

select itemName() from domain

Answer 2

AFAIK SimpleDB does not unique, but other than this:

select itemName() from mydomain order by itemName()

should work, and you can easily remove duplicates (if any) since you get the names in sorted order (like itertools.groupbyin Python and any similar mechanism in any of your favorite languages).