2 Respostas
- Mais recentes
- Mais votos
- Mais comentários
0
In testing, I've found that table names which include a dash must be quoted. For example:
SELECT * FROM "habits_sensors-playground";
SELECT * FROM "habits_sensors-playground"."userId-gsi" WHERE userId='user1';
Thank you for raising the question - I had not encountered this exception before.
respondido há 3 anos
0
Thank you Pete, that did the trick. Not easy to spot, I did try single quotes but not the double ones.
The dash comes from amplify appending the env name to the table so I guess it can happen to others as well.
respondido há 3 anos
Conteúdo relevante
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 9 meses