How to insert new row in Postgres table?

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, May 25 '15 at 15:03
Show all code involved please. You don't have `SELECT COUNT(*)...` in the code shown... — Luc M, May 25 '15 at 15:03
Please do not downvote me, the query i posted above is that i'm executing! — smartmouse, May 25 '15 at 15:05
Do not use PhpPgAdmin. In any reasonable SQL editor you wont get such error. — Ihor Romanchenko, May 25 '15 at 16:19

score 2 · Accepted Answer · edited May 23 '17 at 11:43

2

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

edited May 23 '17 at 11:43

Community

answered May 25 '15 at 15:05

niketshah90

Works, thank you! Someone downvote my question because was not so expert like you! – smartmouse May 25 '15 at 15:09

1 Answers1