Top "Quoted-identifier" questions

When do Postgres column or table names need quotes and when don't they?

Let's consider the following postgres query: SELECT * FROM "MY_TABLE" WHERE "bool_var"=FALSE AND "str_var"='something'; The query …

postgresql quoted-identifier

Postgresql Column Doesn't Exist

I'm running a simple select query: SELECT return_part_i.CntrctTrmntnInd FROM return_part_i LIMIT 10; And getting the following …

sql postgresql quoted-identifier

Postgres with Java I can't insert data

I tried to make an insert to my postgres database with Java. I have default configuration for my local database. …

java postgresql sql-insert quoted-identifier