sql.nanorc (2444B)
1 ## Syntax highlighting for (Postgres) SQL scripts. 2 3 ## Original author: Devrim Gündüz 4 5 syntax sql "\.sql$" 6 comment "-- " 7 8 # Types. 9 icolor #0a4 "\<(integer|int[248]|(big|small)?(int|serial)|decimal|numeric|real|double precision)\>" 10 icolor #0a4 "\<(bit( varying)?|boolean|bytea|enum|money|tsquery|tsvector|uuid|xml)\>" 11 icolor #0a4 "\<(char|varchar|character( varying)?|text|cidr|inet|macaddr8?)\>" 12 icolor #0a4 "\<(date|interval|time(stamp)?( with(out)? time zone)?)\>" 13 icolor #0a4 "\<(box|circle|line|lseg|path|point|polygon)\>" 14 icolor #0a4 "\<(date|int[48]|num|ts|tstz)range\>" 15 16 # SQL keywords. 17 icolor #48c "\<(ABORT|AGGREGATE|ALL|ALTER|ANALYZE|AND|ANY|AS|BEGIN|BETWEEN|CAST|CHECKPOINT)\>" 18 icolor #48c "\<(CLOSE|CLUSTER|COLLATION|COMMENT|COMMIT|CONSTRAINTS?|CONVERSION|COPY|CREATE)\>" 19 icolor #48c "\<(DATABASE|DEALLOCATE|DECLARE|DEFAULT|DELETE|DISCARD|DISTINCT|DO|DOMAIN|DROP)\>" 20 icolor #48c "\<(END|EXCEPT|EXECUTE|EXISTS|EXPLAIN|EXTENSION|FALSE|FETCH|FOREIGN (DATA WRAPPER|SCHEMA|TABLE))\>" 21 icolor #48c "\<(FROM|FUNCTION|GRANT|GROUP( BY)?|HAVING|IN|INDEX|INSERT|INTERSECT|INTO|IS)\>" 22 icolor #48c "\<(NATURAL )?(INNER |OUTER |CROSS |(LEFT|RIGHT|FULL)( OUTER)? )?JOIN\>" 23 icolor #48c "\<((PRIMARY|FOREIGN) KEY|LANGUAGE|LOAD|LIKE|LOCK|MOVE|NOT|NOTIFY|NULL)\>" 24 icolor #48c "\<(ON|ONLY|OPERATOR( CLASS| FAMILY)?|OR|ORDER BY|PREPARED?|PRIVILEGES|PROCEDURE)\>" 25 icolor #48c "\<(REFERENCES|RELEASE|REPLACE|RESET|RETURN(S|ING)|REVOKE|ROLE|ROLLBACK|RULE|SAVEPOINT|SCHEMA)\>" 26 icolor #48c "\<(SELECT|SEQUENCE|SERVER|SESSION AUTHORIZATION|SET|SHOW|SIMILAR|START|SYSTEM)\>" 27 icolor #48c "\<(TABLE(SPACE)?|TEXT SEARCH (CONFIGURATION|DICTIONARY|PARSER|TEMPLATE))\>" 28 icolor #48c "\<(TO|TRANSACTION|(EVENT )?TRIGGER|TRUE|TRUNCATE|TYPE|UNION|UNIQUE|UPDATE|USER( MAPPING)?|USING)\>" 29 icolor #48c "\<(VACUUM|VALUES|((REFRESH )?MATERIALIZED )?VIEW|WHERE|WITH)\>" 30 31 # Flow control. 32 icolor #cc0 "\<(CASE|WHEN|IF|THEN|ELSE|ELSE?IF|LOOP|CONTINUE|EXIT)\>" 33 icolor #cc0 "\<(FOR|FOREACH|IN|WHILE|END (CASE|IF|LOOP))\>" 34 icolor #a4a "\<(RAISE|EXCEPTION|NOTICE|RETURN)\>" 35 36 # Quoted identifiers. 37 color normal ""[[:alpha:]_][[:alnum:]_$]*"" 38 39 # Strings. 40 color #4c0 "'([^']|\\')*'" 41 42 # Trailing whitespace. 43 color ,green "[[:space:]]+$" 44 45 # Comments. 46 color italic,#c44 "(--|//).*" 47 color italic,#c44 start="/\*" end="\*/" 48 49 # PostgreSQL default schemas. 50 color grey "\<(pg_catalog|public)\>" 51 52 # PostgreSQL PLs. 53 color #c08 "\<(SQL|pl(java|perlu?|pgsql|py|pythonu?|r|ruby|scheme|sh|tcl))\>"