Insert Query in postgre not working

General
1

Hello there , Greetings ! I' working on Postgresql and I want to insert the query into it but it is not inserting into it.
This is syntax of query
image

This is flow,

image
image1671Ă—398 25.3 KB

and this is pgadmin table

image

2

Look at the column "Title" vs "title".

3

I also tried that one but didn't get the anything

image
image1671Ă—418 33.2 KB

4

Did you deploy this change ?

5

Yes this is after photo

6

rename your column to title - lowercase unless you want to deal with:

All identifiers (including column names) that are not double-quoted are folded to lower case in PostgreSQL. Column names that were created with double-quotes and thereby retained upper-case letters (and/or other syntax violations) have to be double-quoted for the rest of their life: ( "first_Name" )

small tip: use SERIAL PRIMARY KEY for the id field, then you don't have to insert a number and it will be autogenerated.

7

after changing Title to title in pgadmin what should the value look like i got an error on it.

image
image735Ă—591 15.3 KB

image
image1667Ă—350 23.5 KB

8

but if i give it as parameter it got successful on it.

image
image1668Ă—578 42.5 KB

9

because you used backticks and postgres will assume that is a column.

i cannot copy your code (screenshot) but you need to use double quotes for the query and in your query use single quotes for strings, ie.:

query: "insert into test (title) values ('test4')"

(assumes autokey generation for id)

1 Like
10

Thank you It is working now