2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
répondu il y a 3 ans
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.
répondu il y a 3 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 7 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an