SQL error 42601 in pgAdmin

[apitos]

Hi all,

Why do I have an SQL state error: 42601, on this query:

ALTER TABLE user
     ALTER COLUMN password TYPE VARCHAR(100);

ERROR: syntax error at or near "user"
LINE 1: ALTER TABLE user
                    ^
SQL state: 42601
Character: 13

Thanks.

[ilenia]

what SQL instance are you using?

see here for example, the syntax varies
SQL ALTER TABLE Statement (w3schools.com)

[apitos]

Hi ilenia,

Thank you for your help.

I would like to share the solution I found with others so that someone may benefit from it.

Postgresql: syntax error at or near "user"