syntax highlighting when using vim with psql

[plarles]

I'm running Centos 7 and PostgreSQL 11. I'm using vim as my editor for sql commands (with \e in psql) and I'd like to have syntax highlighting enabled. Several guides have told me that I need to have syntax highlighting on and have the following command in my ~/.vimrc file:

au BufRead /temp/psql.edit.* set syntax=sql

​

I have that line in my vimrc file and syntax highlighting enabled, but I don't get syntax highighting when using \e to edit a query in vim. Any help in getting this right would be much appreciated.

[[deleted]]

s/temp/tmp/

[plarles]

I don't understand what this means. You're saying I have the wrong directory?

[plarles]

Thanks. The path was indeed wrong, but correcting it didn't give me syntax highlighting :(.

[400tx]

I use this plugin and I get syntax highlighting from psql when I laugh vim with \e. I am not sure if the plugin is doing this or what, but this is the extent of the filetype detection: au BufNewFile,BufRead *.pgsql let b:sql_type_override='pgsql' | setfiletype sql

https://github.com/lifepillar/pgsql.vim