## Here is an example for PostgreSQL.

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 is in `backticks` or like %x{this}.  These are

# "double-quotish" (to use a perlism).

color brightblue "`[^`]*`" "%x\{[^}]*\}"

# Strings, double-quoted.

color green ""([^"]|(\\"))*"" "%[QW]?\{[^}]*\}" "%[QW]?\([^)]*\)" "%[QW]?<[^>]*>"

color green "%[QW]?\[[^]]*\]" "%[QW]?\$[^$]*\$" "%[QW]?\^[^^]*\^" "%[QW]?![^!]*!"

# Expression substitution.  These go inside double-quoted strings,

# "like #{this}".

color brightgreen "#\{[^}]*\}"

# Strings, single-quoted.

color green "'([^']|(\\'))*'" "%[qw]\{[^}]*\}" "%[qw]\([^)]*\)" "%[qw]<[^>]*>"

color green "%[qw]\[[^]]*\]" "%[qw]\$[^$]*\$" "%[qw]\^[^^]*\^" "%[qw]![^!]*!"

# Comments.

color red "#[^{].*$" "#$"

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 "(pljava|plperlu?|plpgsql|plpy|plpythonu?|plr|plruby|plsh|pltcl|plscheme)"