Case in the field name disappears only for me?

[alexsuslov]

Hi!

DBWrapper = require('node-dbi').DBWrapper;
var Config= { host: 'localhost', database: 'tmp'}

var dbWrapper = new DBWrapper('pg', Config);
dbWrapper.connect();

var item = {"sName": 'Milky'};

dbWrapper.update('"Users"."Company"', item, ['\"idCompany\" = 1'], function(err, resp) {
  if (err) {throw err}
  if (resp) {console.log(resp)}
});

error: column "sname" of relation "Company" does not exist

[alexsuslov]

It problem is only with update. Select and insert go normal.
for update i use
""Dragon_Users"."tCompany""
look like voodoo

[olivierphi]

@alexsuslov I don't know postgres enough to be able to solve such a bug, sorry. But I would be glad to work with you and your knowledge of Pg to solve this issue together! :-)