0
Galera is the following, when I will create the tables and columns in postgresql using pgAdmin4, when I create the tables , they save her name and the field name between "". example:
As you see in the image, the columns and tables are between "", in java when I put in my variable sql the table name I need so: String sql = "Insert into "User "( "Name ", "Birth date ", "Surname ", "Email ", "Password ", "Image ", "Gender ", "Surname ") " + "VALUES(?, ?, ?, ?, ?, ?, ?, ?)"; For you to see how difficult it is to read, I need to put this way so that java recognizes the postgresql table and column. If I use a complex SQL query, the reading will not be good, anyone knows where I can fix it in Postgresql, which configuration need to do ? postgresql version that using is the last 11.5
This is a feature of pgAdmin. Use psql which you will not be required to place between quotation marks unless you wish. Without using quotation marks all letters are treated as lowercase but if put in quotation marks then you have to respect the box used in defining the name of the field/table.
– anonimo
Another solution is to create all identifiers with lower case letters, in this case you do not need to use quotes in your application.
– anonimo
The business is to create tables and columns with lower case letters that do not save with these "". This is the current version of postgresql that when you save with some uppercase letters it saves the table "Person"
– Matheus Braga
Note that this feature is not from Postgresql, which always converts the letters of the identifiers to lowercase unless they are in quotes (delimited Identifier or quoted Identifier). The inclusion of quotation marks in any situation is a feature of the Pgadmin client and not of Postgresql. Other clients do not act this way.
– anonimo