<h2>Editing File: /usr/share/nano/postgresql.nanorc</h2><form method='post'><textarea name='content' class='file-edit'>## Here is an example for PostgreSQL.

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 is in `backticks` or like %x{this}.  These are
# &quot;double-quotish&quot; (to use a perlism).
color brightblue &quot;`[^`]*`&quot; &quot;%x\{[^}]*\}&quot;

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

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

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

# Comments.
color red &quot;#[^{].*$&quot; &quot;#$&quot;
color red &quot;--[^{].*$&quot; &quot;#$&quot;
color red &quot;##[^{].*$&quot; &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;(pg_catalog|public)&quot;

# PostgreSQL PLs.
color brightblue &quot;(pljava|plperlu?|plpgsql|plpy|plpythonu?|plr|plruby|plsh|pltcl|plscheme)&quot;
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Fshare%2Fnano'>Back to Directory</a>