## Syntax highlighting for (Postgres) SQL scripts. syntax sql "\.sql[2345s~]?$" comment "-- " # Functions. color white "\<[a-z_]*\(" # Types. color green "\<(int2|smallint|int4|int|integer|int8|bigint|decimal|numeric|real|double precision|(small|big)?serial)\>" color green "\<(bit( varying)?|boolean|bytea|enum|money|tsvector|uuid)\>" color green "\<(char|varchar|character( varying)?|text)\>" color green "\<(date|interval|time(stamp)?( with time zone| without time zone)?)\>" color green "\<(point|line|lseg|path|box|polygon|circle)\>" color green "\<(cidr|inet|macaddr)\>" color green "\<(daterange|int4range|int8range|numrange|tsrange|tstzrange)\>" # Structure. color brightyellow "\<(CASE|CLASS|DEFAULT|DO|ELSE|ELSEIF|FOR|FOREACH|FUNCTION|IF|IS NULL)\>" color brightyellow "\<(NEW|PRIVATE|PUBLIC|RETURN|RETURNS|SETOF|SWITCH|THEN|WHEN|WHILE)>" # Control flow. color magenta "\<(EXCEPTION|NOTICE|RAISE|RETURN)\>" # SQL keywords. color blue "\<(ABORT|AGGREGATE|ALTER|ANALYZE|AND|AS|AUTHORIZATION|BEGIN|CAST|CHECKPOINT|CLASS|CLOSE)\>" color blue "\<(CLUSTER|COLLATION|COMMENT|COMMIT|CONFIGURATION|CONSTRAINTS|CONVERSION|COPY|CREATE)\>" color blue "\<(DATA|DATABASE|DEALLOCATE|DECLARE|DEFAULT|DELETE|DICTIONARY|DISCARD|DO|DOMAIN|DROP)\>" color blue "\<(END|EVENT|EXECUTE|EXPLAIN|EXTENSION|FAMILY|FETCH|FOREIGN|FROM|FUNCTION)\>" color blue "\<(GRANT|GROUP|IF NOT EXISTS|IMMUTABLE|INDEX|INSERT|INTO|LABEL|LANGUAGE|LARGE|LOAD|LOCK)\>" color blue "\<(MAPPING FOR|MATERIALIZED|MOVE|NOTIFY|OBJECT|OPERATOR|OPTIONS|OWNED|OWNER)\>" color blue "\<(PARSER|PREPARED?|PRIVILEGES|REASSIGN|REFRESH|RELEASE|RESET|REVOKE|ROLE|ROLLBACK|RULE)\>" color blue "\<(SAVEPOINT|SCHEMA|SEARCH|SECURITY|SELECT|SEQUENCE|SERVER|SESSION|SET|SHOW|SPACE|START|SYSTEM)\>" color blue "\<(TABLE|TEXT|TO|TRANSACTION|TYPE|UPDATE|USER|VACUUM|VALUES|VIEW|WHERE|WITH|WRAPPER)\>" # Strings. color brightyellow "<[^= ]*>" ""(\.|[^"])*"" # Trailing whitespace. color ,green "[[:space:]]+$" # Regular expressions. color brightmagenta "/([^/]|(\\/))*/[iomx]*" "%r\{([^}]|(\\}))*\}[iomx]*" # Shell command expansion, between `backticks` or like %x{this}. color brightblue "`[^`]*`" "%x\{[^}]*\}" # Strings, double-quoted. color green ""([^"]|(\\"))*"" "%[QW]?(![^!]*!|\$[^$]*\$|\^[^^]*\^)" color green "%[QW]?(\([^)]*\)|<[^>]*>|\[[^]]*\]|\{[^}]*\})" # Expression substitution for inside double-quoted strings, "like #{this}". color brightgreen "#\{[^}]*\}" # Strings, single-quoted. color green "'([^']|(\\'))*'" "%[qw](![^!]*!|\$[^$]*\$|\^[^^]*\^)" color green "%[qw](\([^)]*\)|<[^>]*>|\[[^]]*\]|\{[^}]*\})" # Comments. color red "##?([^{].*|$)" color red "--([^{].*|$)" color brightblue "//.*" color brightblue start="/\*" end="\*/" # PostgreSQL markings. color red "--" # PostgreSQL default schemas. color brightred "\<(pg_catalog|public)\>" # PostgreSQL PLs. color brightblue "\<pl(java|perlu?|pgsql|py|pythonu?|r|ruby|scheme|sh|tcl)\>" SIMPAN PERUBAHAN