How to specify mode for .sql files?

I know you can set ALL .sql files to be SQL (PostgreSQL) via Preferences, but I am trying to do it for a select few files. I tried using the Emacs mode line, without success: -- -*- mode: SQL (PostgreSQL); -*- on the first line I would have thought it would work. For example, I can do: -- -*-

Re: How to specify mode for .sql files?

On Monday, November 9, 2015, Jeremy Cowgar wrote: -- -*- mode: SQL (PostgreSQL); -*- Mode names can't have spaces in them; to turn a language name into a mode name, replace all of the spaces with dashes and making the rest lower case (although the latter is just a matter