node postgres insert syntax error

Question

I'm trying to switch my psql setup over to node, and can't get the following test query to work.

PG = require('pg')

module.exports = class Postgres extends Backbone.Model
    initialize: =>
        PG.connect process.env.DATABASE_URL, (error, client) =>
            this.client = client

            this.sendMessage(1, 2, '3')


    sendMessage: (from, to, message) =>
        this.client.query('INSERT INTO messages(from, to, content) VALUES($1, $2, $3) RETURNING id', [from, to, message], (error, result) =>
            console.log 'error', error
            console.log 'result', result
        )

Responds with the following error:

 error { [error: syntax error at or near "from"]

What am I doing wrong?

I don't know if it matters, but here's my table. enter image description here

Converted my commented into an answer, so people can spot it more easily.. Cheers, August! — AdrianoKF
– AdrianoKF, Commented Jul 22, 2015 at 7:32

AdrianoKF · Accepted Answer · 2015-07-22 07:32:02Z

2

I think Postgres is complaining about the reserved keyword from as a column identifier.

You should try double-quoting it in your query like this:

INSERT INTO messages("from", to, content) [...]

answered Jul 22, 2015 at 7:32

AdrianoKF

3,0311 gold badge28 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

node postgres insert syntax error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related