CODEWITHSUNDEEP
node.jspostgresqlnode-postgres
Onilol
Onilol

Reputation: 1339

AS statement ignoring cases in PSQL

We are using the Node Postgres client to run some queries on our database, like:

await client.query('SELECT A.date_time AS dateTime FROM A')

the problem is that returned value for the row comes as:

Expected:{
  dateTime: '2009-06-16 11:00:00'
}

Received: {
  datetime: '2009-06-16 11:00:00'
}

is this a bug or are we missing a configuration somewhere?

Upvotes: 0

Views: 99

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246878

SQL is case sensitive, but everything that is not a string literal or a quoted identifier is case folded. The SQL standard prescribes case folding to upper case, but PostgreSQL folds to lower case.

If you want case to be preserved in an identifier like dateTime, you have to surround it with double quotes: "dateTime"

Upvotes: 2

Related Questions