Visual Studio configuration for PostgreSQL .sql files

Question

I'm using VS2013 to edit .sql files intended for PostgreSQL. VS thinks they are for SQL Server, and spews all sorts of distracting errors and warnings because the syntax is slightly different.

What is the best way to configure VS for editing .sql files that are not intended for SQL Server in general, or for PostgreSQL in particular?

(Preferably without VS plugins, unless there is a fantastic stable plugin.)

Can I just disable the SQL Server specific bits somehow? Do I have to associate the .sql files with a plain text editor mode and lose syntax highlighting entirely?

Answer 1

Go to Tools -> Options -> Text Editor/SQL Server Tools -> Intellisense and turn Intellisense off. That will make the warnings go away.