How to insert new row in Postgres table? [duplicate]

Question

i'm using for the first times Postgres and i'm experiencing problems adding a new row by SQL code.

Here is my table structure:

enter image description here

And here is the code that i'm executing:

INSERT INTO recensione (testo, voto, utente, merchant) VALUES
('this is a text', 2, 'username', 1234567);

I get this error:

ERROR:  syntax error at or near "INTO" LINE 1: SELECT COUNT(*) AS     total FROM (INSERT INTO recensione (testo...

I'm sure it is easy to solve, but i'm getting crazy about it. Thank you.

Based on the error you seem to have the INSERT INTO as a sub-query of something else. — David Hoelzer
– David Hoelzer, Commented May 25, 2015 at 15:03
Show all code involved please. You don't have SELECT COUNT(*)... in the code shown... — Luc M
– Luc M, Commented May 25, 2015 at 15:03
Please do not downvote me, the query i posted above is that i'm executing! — smartmouse
– smartmouse, Commented May 25, 2015 at 15:05
Do not use PhpPgAdmin. In any reasonable SQL editor you wont get such error. — Ihor Romanchenko
– Ihor Romanchenko, Commented May 25, 2015 at 16:19

Community · Accepted Answer · 2017-05-23 11:43:45Z

2

it happens only when checkbox "Paginate results" on query page is set to on. Try unchecking that.

CommunityBot

11 silver badge

answered May 25, 2015 at 15:05

niketshah90

1991 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Works, thank you! Someone downvote my question because was not so expert like you!