<h2>Edit File: sql.nanorc</h2><form method="post"><textarea name="content" rows="20" cols="80">## Syntax highlighting for (Postgres) SQL scripts.

syntax sql &quot;\.sql[2345s~]?$&quot;
comment &quot;-- &quot;

# Functions.
color white &quot;\&lt;[a-z_]*\(&quot;

# Types.
color green &quot;\&lt;(int2|smallint|int4|int|integer|int8|bigint|decimal|numeric|real|double precision|(small|big)?serial)\&gt;&quot;
color green &quot;\&lt;(bit( varying)?|boolean|bytea|enum|money|tsvector|uuid)\&gt;&quot;
color green &quot;\&lt;(char|varchar|character( varying)?|text)\&gt;&quot;
color green &quot;\&lt;(date|interval|time(stamp)?( with time zone| without time zone)?)\&gt;&quot;
color green &quot;\&lt;(point|line|lseg|path|box|polygon|circle)\&gt;&quot;
color green &quot;\&lt;(cidr|inet|macaddr)\&gt;&quot;
color green &quot;\&lt;(daterange|int4range|int8range|numrange|tsrange|tstzrange)\&gt;&quot;

# Structure.
color brightyellow &quot;\&lt;(CASE|CLASS|DEFAULT|DO|ELSE|ELSEIF|FOR|FOREACH|FUNCTION|IF|IS NULL)\&gt;&quot;
color brightyellow &quot;\&lt;(NEW|PRIVATE|PUBLIC|RETURN|RETURNS|SETOF|SWITCH|THEN|WHEN|WHILE)&gt;&quot;

# Control flow.
color magenta &quot;\&lt;(EXCEPTION|NOTICE|RAISE|RETURN)\&gt;&quot;

# SQL keywords.
color blue &quot;\&lt;(ABORT|AGGREGATE|ALTER|ANALYZE|AND|AS|AUTHORIZATION|BEGIN|CAST|CHECKPOINT|CLASS|CLOSE)\&gt;&quot;
color blue &quot;\&lt;(CLUSTER|COLLATION|COMMENT|COMMIT|CONFIGURATION|CONSTRAINTS|CONVERSION|COPY|CREATE)\&gt;&quot;
color blue &quot;\&lt;(DATA|DATABASE|DEALLOCATE|DECLARE|DEFAULT|DELETE|DICTIONARY|DISCARD|DO|DOMAIN|DROP)\&gt;&quot;
color blue &quot;\&lt;(END|EVENT|EXECUTE|EXPLAIN|EXTENSION|FAMILY|FETCH|FOREIGN|FROM|FUNCTION)\&gt;&quot;
color blue &quot;\&lt;(GRANT|GROUP|IF NOT EXISTS|IMMUTABLE|INDEX|INSERT|INTO|LABEL|LANGUAGE|LARGE|LOAD|LOCK)\&gt;&quot;
color blue &quot;\&lt;(MAPPING FOR|MATERIALIZED|MOVE|NOTIFY|OBJECT|OPERATOR|OPTIONS|OWNED|OWNER)\&gt;&quot;
color blue &quot;\&lt;(PARSER|PREPARED?|PRIVILEGES|REASSIGN|REFRESH|RELEASE|RESET|REVOKE|ROLE|ROLLBACK|RULE)\&gt;&quot;
color blue &quot;\&lt;(SAVEPOINT|SCHEMA|SEARCH|SECURITY|SELECT|SEQUENCE|SERVER|SESSION|SET|SHOW|SPACE|START|SYSTEM)\&gt;&quot;
color blue &quot;\&lt;(TABLE|TEXT|TO|TRANSACTION|TYPE|UPDATE|USER|VACUUM|VALUES|VIEW|WHERE|WITH|WRAPPER)\&gt;&quot;

# Strings.
color brightyellow &quot;&lt;[^=       ]*&gt;&quot; &quot;&quot;(\.|[^&quot;])*&quot;&quot;

# Trailing whitespace.
color ,green &quot;[[:space:]]+$&quot;

# Regular expressions.
color brightmagenta &quot;/([^/]|(\\/))*/[iomx]*&quot; &quot;%r\{([^}]|(\\}))*\}[iomx]*&quot;

# Shell command expansion, between `backticks` or like %x{this}.
color brightblue &quot;`[^`]*`&quot; &quot;%x\{[^}]*\}&quot;

# Strings, double-quoted.
color green &quot;&quot;([^&quot;]|(\\&quot;))*&quot;&quot; &quot;%[QW]?(![^!]*!|\$[^$]*\$|\^[^^]*\^)&quot;
color green &quot;%[QW]?(\([^)]*\)|&lt;[^&gt;]*&gt;|\[[^]]*\]|\{[^}]*\})&quot;

# Expression substitution for inside double-quoted strings, &quot;like #{this}&quot;.
color brightgreen &quot;#\{[^}]*\}&quot;

# Strings, single-quoted.
color green &quot;&#039;([^&#039;]|(\\&#039;))*&#039;&quot; &quot;%[qw](![^!]*!|\$[^$]*\$|\^[^^]*\^)&quot;
color green &quot;%[qw](\([^)]*\)|&lt;[^&gt;]*&gt;|\[[^]]*\]|\{[^}]*\})&quot;

# Comments.
color red &quot;##?([^{].*|$)&quot;
color red &quot;--([^{].*|$)&quot;
color brightblue &quot;//.*&quot;
color brightblue start=&quot;/\*&quot; end=&quot;\*/&quot;

# PostgreSQL markings.
color red &quot;--&quot;

# PostgreSQL default schemas.
color brightred &quot;\&lt;(pg_catalog|public)\&gt;&quot;

# PostgreSQL PLs.
color brightblue &quot;\&lt;pl(java|perlu?|pgsql|py|pythonu?|r|ruby|scheme|sh|tcl)\&gt;&quot;
</textarea><br><input type="hidden" name="edit_file" value="sql.nanorc"><input type="submit" value="Save"></form>