An improved postgres highlighting config for nano

[sylvar]

Well, I tried to post this on wiki.linuxhelp.net, but I don't seem to be able to create an account, so here it is for posterity:



syntax "postgreSQL" "\.sql$"
icolor red "\<(A(LL|NALY(S|Z)E|ND|NY|RRAY|S|SC|SYMMETRIC|UTHORIZATION)|B(EGIN|ETWEEN|INARY|OTH|Y)|C(ASE|AST|HECK|OALESCE|OLLATE|OLUMN|ONSTRAINT|OPY|REATE|ROSS|URRENT_(DATE|ROLE|TIME|TIMESTAMP|USER))|D(EFAULT|EFERRABLE|ESC|ISTINCT|O|ROP)|E(LSE|
ND|XCEPT)|F(ALSE|OR(EIGN)?|REEZE|ROM|ULL)|GRANT|GROUP|HAVING|I(LIKE|N(ITIALLY|NER|SERT|TERSECT|TO)?|S|SNULL)|JOIN|L(EADING|EFT|IKE|IMIT|OCALTIME(STAMP)?)|N(ATURAL|EW|OT(NULL)?|ULL)|O(FF(SET)?|LD|N|NLY|R|RDER|UTER|VERLAPS)|PLACING|PRIMARY|REFER
ENCES|RIGHT|S(ELECT|ESSION_USER|ET|IMILAR|OME|YMMETRIC)|T(ABLE|HEN|O|RAILING|RUE)|UNION|UNIQUE|USER|USING|UPDATE|VIEW|VERBOSE|WHEN|WHERE|)\>"
color magenta "(\{|\}|\(|\)|\;|\]|\[|`|\\|\$|<|>|!|=|&|\|)"
color yellow "'[^']*'"
color green "--.*$"

You're welcome.