Skip to content
Advertisement

Postgresql column exists, but getting column of relation does not exist

JavaScript

I have a table called messages which has column called replyDate. The event.state.session.lastMessages contains a list of javascript object like so : [ { eventId: '14337275205243615', incomingPreview: 'bonjour', replyConfidence: 1, replySource: 'dialogManager', replyDate: '2021-05-04T16:40:07.242Z', replyPreview: '#!builtin_single-choice-mrFFU_' } ]

I want to save in my DB the values replyDate, but i get the error:

JavaScript

Advertisement

Answer

If you have table names with upper case you have to enclose the table with double quotes

JavaScript
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement