VSCode gives syntax error on SQL type as wrong when it is right

Question

I have a SQL file that's parsed through a PostgreSQL database with no error and I have an annoying highlighting issue in VSCode. msgs is a type of an array of TEXTs.

CREATE TABLE users_chat
(
    id SERIAL PRIMARY KEY,
    user_id INTEGER,
    friend_id INTEGER,
    msgs TEXT[]
);

The [] is getting a red squiggly line and the file is red in the folder. It's annoying.

What can I do to get rid of it?

I'd guess Visual Studio Code doesn't know Postgres syntax. May an extension can teach it? Maybe this one? — sticky bit
– sticky bit, Commented Aug 1, 2020 at 21:07
didn't work. interesting extension tho might play with that one later. — frogtoprincejs
– frogtoprincejs, Commented Aug 1, 2020 at 21:19
thanks for pointing me in the right direction with teaching vscode the syntax that helped me google some other things and got an answer that worked. — frogtoprincejs
– frogtoprincejs, Commented Aug 1, 2020 at 21:28

Nimantha · Accepted Answer · 2022-05-22 05:51:38Z

5

Visual Studio Code vs SQL Formatting vscode
Win: Ctrl+Shift+P / Mac: Cmd+Shift+P
And then type "Change Language Mode".
Then type 'postgresql'

edited May 22, 2022 at 5:51

Nimantha

6,5376 gold badges32 silver badges78 bronze badges

answered Aug 1, 2020 at 21:29

frogtoprincejs

1711 gold badge2 silver badges12 bronze badges

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

Comments

Lelo · Accepted Answer · 2022-07-23 21:02:17Z

2

Besides @frogtoprincejs's answer, you could also rename your ".sql" files to ".psql" so VS Code will automatically interpret it as PostgreSQL

edited Jul 23, 2022 at 21:02

answered May 18, 2022 at 18:08

Lelo

9121 gold badge11 silver badges26 bronze badges

Collectives™ on Stack Overflow

VSCode gives syntax error on SQL type as wrong when it is right

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related