Question 114368 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – Postgres spring jpa column with uppercase error

My POSTGRESQL table column in Uppercase and in entity i mentioned colume name with uppercase using @column but it gives error as column doesnt exists ? Posgress doesn’t support @column with uppercase value

Tags:

2

Answers


  1. 0

    Try to use

    @Column(name="`MYUPCASECOLUMN`")

    Important is the `-charcter.

    Login or Signup to reply.
  2. 0

    Identifiers (including column names) that are not double-quoted are folded to lowercase in PostgreSQL. Column names that were created with double-quotes and thereby retained uppercase letters (and/or other syntax violations) have to be double-quoted for the rest of their life:

    "first_Name"

    Values (string literals / constants) are enclosed in single quotes:

    'xyz'

    You can also check this documentation

    I hope, it helps!

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search