postgresql insert syntax error

[barb woolums]

This is driving me nuts, can't see the problem here.

Here is my table definition

SQL

Code: Select all

INSERT INTO custwelc_section (owner, sheader, scontent) VALUES (5, 'about me', 'vvvvvvvvvvvvvvvvv');

error in phpPgAdmin

SQL error:

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

In statement:
SELECT COUNT(*) AS total FROM (INSERT INTO custwelc_section (owner, sheader, scontent) VALUES (5, 'about me', 'vvvvvvvvvvvvvvvvv')) AS sub

[Christopher]

I don't think you can use an INSERT as a sub-select. Maybe try:

GET DIAGNOSTICS integer_var = ROW_COUNT;

[barb woolums]

I didn't use it as a subselect, that's just how is is displayed in the error. All I entered was the insert statement as shown.

[barb woolums]

It's working now, and the only thing I did was try it in pgadmin