Gecko [ www.jobworksschool.com ]

Name	Size	Permission	Date
__pycache__	[ DIR ]	drwxr-xr-x	2025-08-05 17:02
__init__.py	11.83 KB	-rw-r--r--	2024-02-02 13:26
_ada_builtins.py	1.51 KB	-rw-r--r--	2024-02-02 13:26
_asy_builtins.py	26.65 KB	-rw-r--r--	2024-02-02 13:26
_cl_builtins.py	13.67 KB	-rw-r--r--	2024-02-02 13:26
_cocoa_builtins.py	102.72 KB	-rw-r--r--	2024-02-02 13:26
_csound_builtins.py	17.98 KB	-rw-r--r--	2024-02-02 13:26
_css_builtins.py	12.15 KB	-rw-r--r--	2024-02-02 13:26
_julia_builtins.py	11.6 KB	-rw-r--r--	2024-02-02 13:26
_lasso_builtins.py	131.36 KB	-rw-r--r--	2024-02-02 13:26
_lilypond_builtins.py	105.56 KB	-rw-r--r--	2024-02-02 13:26
_lua_builtins.py	7.93 KB	-rw-r--r--	2024-02-02 13:26
_mapping.py	66.43 KB	-rw-r--r--	2024-02-02 13:26
_mql_builtins.py	24.13 KB	-rw-r--r--	2024-02-02 13:26
_mysql_builtins.py	25.24 KB	-rw-r--r--	2024-02-02 13:26
_openedge_builtins.py	48.24 KB	-rw-r--r--	2024-02-02 13:26
_php_builtins.py	105.4 KB	-rw-r--r--	2024-02-02 13:26
_postgres_builtins.py	13.04 KB	-rw-r--r--	2024-02-02 13:26
_qlik_builtins.py	12.3 KB	-rw-r--r--	2024-02-02 13:26
_scheme_builtins.py	31.8 KB	-rw-r--r--	2024-02-02 13:26
_scilab_builtins.py	51.18 KB	-rw-r--r--	2024-02-02 13:26
_sourcemod_builtins.py	26.15 KB	-rw-r--r--	2024-02-02 13:26
_stan_builtins.py	13.13 KB	-rw-r--r--	2024-02-02 13:26
_stata_builtins.py	26.59 KB	-rw-r--r--	2024-02-02 13:26
_tsql_builtins.py	15.1 KB	-rw-r--r--	2024-02-02 13:26
_usd_builtins.py	1.62 KB	-rw-r--r--	2024-02-02 13:26
_vbscript_builtins.py	4.13 KB	-rw-r--r--	2024-02-02 13:26
_vim_builtins.py	55.73 KB	-rw-r--r--	2024-02-02 13:26
actionscript.py	11.4 KB	-rw-r--r--	2024-02-02 13:26
ada.py	5.2 KB	-rw-r--r--	2024-02-02 13:26
agile.py	876 B	-rw-r--r--	2024-02-02 13:26
algebra.py	9.64 KB	-rw-r--r--	2024-02-02 13:26
ambient.py	2.54 KB	-rw-r--r--	2024-02-02 13:26
amdgpu.py	1.63 KB	-rw-r--r--	2024-02-02 13:26
ampl.py	4.08 KB	-rw-r--r--	2024-02-02 13:26
apdlexer.py	30.04 KB	-rw-r--r--	2024-02-02 13:26
apl.py	3.33 KB	-rw-r--r--	2024-02-02 13:26
archetype.py	11.2 KB	-rw-r--r--	2024-02-02 13:26
arrow.py	3.48 KB	-rw-r--r--	2024-02-02 13:26
arturo.py	11.15 KB	-rw-r--r--	2024-02-02 13:26
asc.py	1.62 KB	-rw-r--r--	2024-02-02 13:26
asm.py	40.28 KB	-rw-r--r--	2024-02-02 13:26
asn1.py	4.16 KB	-rw-r--r--	2024-02-02 13:26
automation.py	19.35 KB	-rw-r--r--	2024-02-02 13:26
bare.py	2.95 KB	-rw-r--r--	2024-02-02 13:26
basic.py	27.27 KB	-rw-r--r--	2024-02-02 13:26
bdd.py	1.61 KB	-rw-r--r--	2024-02-02 13:26
berry.py	3.14 KB	-rw-r--r--	2024-02-02 13:26
bibtex.py	4.61 KB	-rw-r--r--	2024-02-02 13:26
blueprint.py	6.04 KB	-rw-r--r--	2024-02-02 13:26
boa.py	3.82 KB	-rw-r--r--	2024-02-02 13:26
bqn.py	3.26 KB	-rw-r--r--	2024-02-02 13:26
business.py	27.45 KB	-rw-r--r--	2024-02-02 13:26
c_cpp.py	17.53 KB	-rw-r--r--	2024-02-02 13:26
c_like.py	28.52 KB	-rw-r--r--	2024-02-02 13:26
capnproto.py	2.12 KB	-rw-r--r--	2024-02-02 13:26
carbon.py	3.15 KB	-rw-r--r--	2024-02-02 13:26
cddl.py	5.06 KB	-rw-r--r--	2024-02-02 13:26
chapel.py	5.04 KB	-rw-r--r--	2024-02-02 13:26
clean.py	6.25 KB	-rw-r--r--	2024-02-02 13:26
comal.py	3.08 KB	-rw-r--r--	2024-02-02 13:26
compiled.py	1.37 KB	-rw-r--r--	2024-02-02 13:26
configs.py	48.9 KB	-rw-r--r--	2024-02-02 13:26
console.py	4.05 KB	-rw-r--r--	2024-02-02 13:26
cplint.py	1.36 KB	-rw-r--r--	2024-02-02 13:26
crystal.py	15.39 KB	-rw-r--r--	2024-02-02 13:26
csound.py	16.6 KB	-rw-r--r--	2024-02-02 13:26
css.py	24.73 KB	-rw-r--r--	2024-02-02 13:26
d.py	9.64 KB	-rw-r--r--	2024-02-02 13:26
dalvik.py	4.5 KB	-rw-r--r--	2024-02-02 13:26
data.py	26.4 KB	-rw-r--r--	2024-02-02 13:26
dax.py	7.91 KB	-rw-r--r--	2024-02-02 13:26
devicetree.py	3.93 KB	-rw-r--r--	2024-02-02 13:26
diff.py	5.15 KB	-rw-r--r--	2024-02-02 13:26
dns.py	3.69 KB	-rw-r--r--	2024-02-02 13:26
dotnet.py	36.74 KB	-rw-r--r--	2024-02-02 13:26
dsls.py	35.92 KB	-rw-r--r--	2024-02-02 13:26
dylan.py	10.08 KB	-rw-r--r--	2024-02-02 13:26
ecl.py	6.22 KB	-rw-r--r--	2024-02-02 13:26
eiffel.py	2.63 KB	-rw-r--r--	2024-02-02 13:26
elm.py	3.08 KB	-rw-r--r--	2024-02-02 13:26
elpi.py	6.55 KB	-rw-r--r--	2024-02-02 13:26
email.py	4.63 KB	-rw-r--r--	2024-02-02 13:26
erlang.py	18.72 KB	-rw-r--r--	2024-02-02 13:26
esoteric.py	10.15 KB	-rw-r--r--	2024-02-02 13:26
ezhil.py	3.2 KB	-rw-r--r--	2024-02-02 13:26
factor.py	19.07 KB	-rw-r--r--	2024-02-02 13:26
fantom.py	9.96 KB	-rw-r--r--	2024-02-02 13:26
felix.py	9.42 KB	-rw-r--r--	2024-02-02 13:26
fift.py	1.58 KB	-rw-r--r--	2024-02-02 13:26
floscript.py	2.61 KB	-rw-r--r--	2024-02-02 13:26
forth.py	7.03 KB	-rw-r--r--	2024-02-02 13:26
fortran.py	10.1 KB	-rw-r--r--	2024-02-02 13:26
foxpro.py	25.6 KB	-rw-r--r--	2024-02-02 13:26
freefem.py	26.28 KB	-rw-r--r--	2024-02-02 13:26
func.py	3.54 KB	-rw-r--r--	2024-02-02 13:26
functional.py	674 B	-rw-r--r--	2024-02-02 13:26
futhark.py	3.64 KB	-rw-r--r--	2024-02-02 13:26
gcodelexer.py	826 B	-rw-r--r--	2024-02-02 13:26
gdscript.py	7.37 KB	-rw-r--r--	2024-02-02 13:26
go.py	3.7 KB	-rw-r--r--	2024-02-02 13:26
grammar_notation.py	7.79 KB	-rw-r--r--	2024-02-02 13:26
graph.py	4.01 KB	-rw-r--r--	2024-02-02 13:26
graphics.py	38.11 KB	-rw-r--r--	2024-02-02 13:26
graphql.py	5.47 KB	-rw-r--r--	2024-02-02 13:26
graphviz.py	1.89 KB	-rw-r--r--	2024-02-02 13:26
gsql.py	3.9 KB	-rwxr-xr-x	2024-02-02 13:26
haskell.py	32.13 KB	-rw-r--r--	2024-02-02 13:26
haxe.py	30.25 KB	-rw-r--r--	2024-02-02 13:26
hdl.py	21.99 KB	-rw-r--r--	2024-02-02 13:26
hexdump.py	3.52 KB	-rw-r--r--	2024-02-02 13:26
html.py	19.79 KB	-rw-r--r--	2024-02-02 13:26
idl.py	15.09 KB	-rw-r--r--	2024-02-02 13:26
igor.py	30.92 KB	-rw-r--r--	2024-02-02 13:26
inferno.py	3.06 KB	-rw-r--r--	2024-02-02 13:26
installers.py	12.87 KB	-rw-r--r--	2024-02-02 13:26
int_fiction.py	55.78 KB	-rw-r--r--	2024-02-02 13:26
iolang.py	1.86 KB	-rw-r--r--	2024-02-02 13:26
j.py	4.74 KB	-rw-r--r--	2024-02-02 13:26
javascript.py	61.39 KB	-rw-r--r--	2024-02-02 13:26
jmespath.py	2.01 KB	-rw-r--r--	2024-02-02 13:26
jslt.py	3.61 KB	-rw-r--r--	2024-02-02 13:26
jsonnet.py	5.5 KB	-rw-r--r--	2024-02-02 13:26
jsx.py	2.18 KB	-rw-r--r--	2024-02-02 13:26
julia.py	11.37 KB	-rw-r--r--	2024-02-02 13:26
jvm.py	71.22 KB	-rw-r--r--	2024-02-02 13:26
kuin.py	11.14 KB	-rw-r--r--	2024-02-02 13:26
kusto.py	3.4 KB	-rw-r--r--	2024-02-02 13:26
ldap.py	6.4 KB	-rw-r--r--	2024-02-02 13:26
lean.py	4.2 KB	-rw-r--r--	2024-02-02 13:26
lilypond.py	9.52 KB	-rw-r--r--	2024-02-02 13:26
lisp.py	141.01 KB	-rw-r--r--	2024-02-02 13:26
macaulay2.py	31.42 KB	-rw-r--r--	2024-02-02 13:26
make.py	7.51 KB	-rw-r--r--	2024-02-02 13:26
markup.py	58.84 KB	-rw-r--r--	2024-02-02 13:26
math.py	676 B	-rw-r--r--	2024-02-02 13:26
matlab.py	129.74 KB	-rw-r--r--	2024-02-02 13:26
maxima.py	2.65 KB	-rw-r--r--	2024-02-02 13:26
meson.py	4.24 KB	-rw-r--r--	2024-02-02 13:26
mime.py	7.36 KB	-rw-r--r--	2024-02-02 13:26
minecraft.py	13.49 KB	-rw-r--r--	2024-02-02 13:26
mips.py	4.5 KB	-rw-r--r--	2024-02-02 13:26
ml.py	34.49 KB	-rw-r--r--	2024-02-02 13:26
modeling.py	13.21 KB	-rw-r--r--	2024-02-02 13:26
modula2.py	51.83 KB	-rw-r--r--	2024-02-02 13:26
monte.py	6.14 KB	-rw-r--r--	2024-02-02 13:26
mosel.py	8.97 KB	-rw-r--r--	2024-02-02 13:26
ncl.py	62.46 KB	-rw-r--r--	2024-02-02 13:26
nimrod.py	6.27 KB	-rw-r--r--	2024-02-02 13:26
nit.py	2.66 KB	-rw-r--r--	2024-02-02 13:26
nix.py	4.29 KB	-rw-r--r--	2024-02-02 13:26
oberon.py	4.07 KB	-rw-r--r--	2024-02-02 13:26
objective.py	22.42 KB	-rw-r--r--	2024-02-02 13:26
ooc.py	2.91 KB	-rw-r--r--	2024-02-02 13:26
openscad.py	3.61 KB	-rw-r--r--	2024-02-02 13:26
other.py	1.7 KB	-rw-r--r--	2024-02-02 13:26
parasail.py	2.66 KB	-rw-r--r--	2024-02-02 13:26
parsers.py	25.3 KB	-rw-r--r--	2024-02-02 13:26
pascal.py	30.16 KB	-rw-r--r--	2024-02-02 13:26
pawn.py	7.96 KB	-rw-r--r--	2024-02-02 13:26
perl.py	38.25 KB	-rw-r--r--	2024-02-02 13:26
phix.py	22.71 KB	-rw-r--r--	2024-02-02 13:26
php.py	12.73 KB	-rw-r--r--	2024-02-02 13:26
pointless.py	1.93 KB	-rw-r--r--	2024-02-02 13:26
pony.py	3.17 KB	-rw-r--r--	2024-02-02 13:26
praat.py	12.38 KB	-rw-r--r--	2024-02-02 13:26
procfile.py	1.13 KB	-rw-r--r--	2024-02-02 13:26
prolog.py	12.21 KB	-rw-r--r--	2024-02-02 13:26
promql.py	4.6 KB	-rw-r--r--	2024-02-02 13:26
prql.py	8.54 KB	-rw-r--r--	2024-02-02 13:26
ptx.py	4.4 KB	-rw-r--r--	2024-02-02 13:26
python.py	52.15 KB	-rw-r--r--	2024-02-02 13:26
q.py	6.77 KB	-rw-r--r--	2024-02-02 13:26
qlik.py	3.58 KB	-rw-r--r--	2024-02-02 13:26
qvt.py	5.93 KB	-rw-r--r--	2024-02-02 13:26
r.py	6.04 KB	-rw-r--r--	2024-02-02 13:26
rdf.py	15.61 KB	-rw-r--r--	2024-02-02 13:26
rebol.py	17.82 KB	-rw-r--r--	2024-02-02 13:26
resource.py	2.83 KB	-rw-r--r--	2024-02-02 13:26
ride.py	4.94 KB	-rw-r--r--	2024-02-02 13:26
rita.py	1.1 KB	-rw-r--r--	2024-02-02 13:26
rnc.py	1.93 KB	-rw-r--r--	2024-02-02 13:26
roboconf.py	1.92 KB	-rw-r--r--	2024-02-02 13:26
robotframework.py	18.02 KB	-rw-r--r--	2024-02-02 13:26
ruby.py	22.14 KB	-rw-r--r--	2024-02-02 13:26
rust.py	8.02 KB	-rw-r--r--	2024-02-02 13:26
sas.py	9.18 KB	-rw-r--r--	2024-02-02 13:26
savi.py	4.54 KB	-rw-r--r--	2024-02-02 13:26
scdoc.py	2.47 KB	-rw-r--r--	2024-02-02 13:26
scripting.py	68.37 KB	-rw-r--r--	2024-02-02 13:26
sgf.py	1.94 KB	-rw-r--r--	2024-02-02 13:26
shell.py	35.61 KB	-rw-r--r--	2024-02-02 13:26
sieve.py	2.38 KB	-rw-r--r--	2024-02-02 13:26
slash.py	8.28 KB	-rw-r--r--	2024-02-02 13:26
smalltalk.py	7.04 KB	-rw-r--r--	2024-02-02 13:26
smithy.py	2.6 KB	-rw-r--r--	2024-02-02 13:26
smv.py	2.71 KB	-rw-r--r--	2024-02-02 13:26
snobol.py	2.67 KB	-rw-r--r--	2024-02-02 13:26
solidity.py	3.05 KB	-rw-r--r--	2024-02-02 13:26
sophia.py	3.25 KB	-rw-r--r--	2024-02-02 13:26
special.py	3.33 KB	-rw-r--r--	2024-02-02 13:26
spice.py	2.67 KB	-rw-r--r--	2024-02-02 13:26
sql.py	41.12 KB	-rw-r--r--	2024-02-02 13:26
srcinfo.py	1.65 KB	-rw-r--r--	2024-02-02 13:26
stata.py	6.27 KB	-rw-r--r--	2024-02-02 13:26
supercollider.py	3.61 KB	-rw-r--r--	2024-02-02 13:26
tal.py	2.83 KB	-rw-r--r--	2024-02-02 13:26
tcl.py	5.38 KB	-rw-r--r--	2024-02-02 13:26
teal.py	3.44 KB	-rw-r--r--	2024-02-02 13:26
templates.py	70.91 KB	-rw-r--r--	2024-02-02 13:26
teraterm.py	9.49 KB	-rw-r--r--	2024-02-02 13:26
testing.py	10.51 KB	-rw-r--r--	2024-02-02 13:26
text.py	1 KB	-rw-r--r--	2024-02-02 13:26
textedit.py	7.43 KB	-rw-r--r--	2024-02-02 13:26
textfmts.py	14.95 KB	-rw-r--r--	2024-02-02 13:26
theorem.py	16.27 KB	-rw-r--r--	2024-02-02 13:26
thingsdb.py	4.13 KB	-rw-r--r--	2024-02-02 13:26
tlb.py	1.34 KB	-rw-r--r--	2024-02-02 13:26
tls.py	1.5 KB	-rw-r--r--	2024-02-02 13:26
tnt.py	10.21 KB	-rw-r--r--	2024-02-02 13:26
trafficscript.py	1.44 KB	-rw-r--r--	2024-02-02 13:26
typoscript.py	8.01 KB	-rw-r--r--	2024-02-02 13:26
ul4.py	8.75 KB	-rw-r--r--	2024-02-02 13:26
unicon.py	18.08 KB	-rw-r--r--	2024-02-02 13:26
urbi.py	5.9 KB	-rw-r--r--	2024-02-02 13:26
usd.py	3.43 KB	-rw-r--r--	2024-02-02 13:26
varnish.py	7.1 KB	-rw-r--r--	2024-02-02 13:26
verification.py	3.79 KB	-rw-r--r--	2024-02-02 13:26
verifpal.py	2.6 KB	-rw-r--r--	2024-02-02 13:26
vip.py	5.58 KB	-rw-r--r--	2024-02-02 13:26
vyper.py	5.46 KB	-rw-r--r--	2024-02-02 13:26
web.py	894 B	-rw-r--r--	2024-02-02 13:26
webassembly.py	5.57 KB	-rw-r--r--	2024-02-02 13:26
webidl.py	10.27 KB	-rw-r--r--	2024-02-02 13:26
webmisc.py	39.6 KB	-rw-r--r--	2024-02-02 13:26
wgsl.py	11.64 KB	-rw-r--r--	2024-02-02 13:26
whiley.py	3.92 KB	-rw-r--r--	2024-02-02 13:26
wowtoc.py	3.93 KB	-rw-r--r--	2024-02-02 13:26
wren.py	3.16 KB	-rw-r--r--	2024-02-02 13:26
x10.py	1.88 KB	-rw-r--r--	2024-02-02 13:26
xorg.py	902 B	-rw-r--r--	2024-02-02 13:26
yang.py	4.39 KB	-rw-r--r--	2024-02-02 13:26
yara.py	2.37 KB	-rw-r--r--	2024-02-02 13:26
zig.py	3.86 KB	-rw-r--r--	2024-02-02 13:26

Rename

"""
    pygments.lexers._postgres_builtins
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Self-updating data files for PostgreSQL lexer.

Run with `python -I` to update itself.

:copyright: Copyright 2006-2023 by the Pygments team, see AUTHORS.
    :license: BSD, see LICENSE for details.
"""

# Autogenerated: please edit them if you like wasting your time.

KEYWORDS = (
    'ABORT',
    'ABSOLUTE',
    'ACCESS',
    'ACTION',
    'ADD',
    'ADMIN',
    'AFTER',
    'AGGREGATE',
    'ALL',
    'ALSO',
    'ALTER',
    'ALWAYS',
    'ANALYSE',
    'ANALYZE',
    'AND',
    'ANY',
    'ARRAY',
    'AS',
    'ASC',
    'ASENSITIVE',
    'ASSERTION',
    'ASSIGNMENT',
    'ASYMMETRIC',
    'AT',
    'ATOMIC',
    'ATTACH',
    'ATTRIBUTE',
    'AUTHORIZATION',
    'BACKWARD',
    'BEFORE',
    'BEGIN',
    'BETWEEN',
    'BIGINT',
    'BINARY',
    'BIT',
    'BOOLEAN',
    'BOTH',
    'BREADTH',
    'BY',
    'CACHE',
    'CALL',
    'CALLED',
    'CASCADE',
    'CASCADED',
    'CASE',
    'CAST',
    'CATALOG',
    'CHAIN',
    'CHAR',
    'CHARACTER',
    'CHARACTERISTICS',
    'CHECK',
    'CHECKPOINT',
    'CLASS',
    'CLOSE',
    'CLUSTER',
    'COALESCE',
    'COLLATE',
    'COLLATION',
    'COLUMN',
    'COLUMNS',
    'COMMENT',
    'COMMENTS',
    'COMMIT',
    'COMMITTED',
    'COMPRESSION',
    'CONCURRENTLY',
    'CONFIGURATION',
    'CONFLICT',
    'CONNECTION',
    'CONSTRAINT',
    'CONSTRAINTS',
    'CONTENT',
    'CONTINUE',
    'CONVERSION',
    'COPY',
    'COST',
    'CREATE',
    'CROSS',
    'CSV',
    'CUBE',
    'CURRENT',
    'CURRENT_CATALOG',
    'CURRENT_DATE',
    'CURRENT_ROLE',
    'CURRENT_SCHEMA',
    'CURRENT_TIME',
    'CURRENT_TIMESTAMP',
    'CURRENT_USER',
    'CURSOR',
    'CYCLE',
    'DATA',
    'DATABASE',
    'DAY',
    'DEALLOCATE',
    'DEC',
    'DECIMAL',
    'DECLARE',
    'DEFAULT',
    'DEFAULTS',
    'DEFERRABLE',
    'DEFERRED',
    'DEFINER',
    'DELETE',
    'DELIMITER',
    'DELIMITERS',
    'DEPENDS',
    'DEPTH',
    'DESC',
    'DETACH',
    'DICTIONARY',
    'DISABLE',
    'DISCARD',
    'DISTINCT',
    'DO',
    'DOCUMENT',
    'DOMAIN',
    'DOUBLE',
    'DROP',
    'EACH',
    'ELSE',
    'ENABLE',
    'ENCODING',
    'ENCRYPTED',
    'END',
    'ENUM',
    'ESCAPE',
    'EVENT',
    'EXCEPT',
    'EXCLUDE',
    'EXCLUDING',
    'EXCLUSIVE',
    'EXECUTE',
    'EXISTS',
    'EXPLAIN',
    'EXPRESSION',
    'EXTENSION',
    'EXTERNAL',
    'EXTRACT',
    'FALSE',
    'FAMILY',
    'FETCH',
    'FILTER',
    'FINALIZE',
    'FIRST',
    'FLOAT',
    'FOLLOWING',
    'FOR',
    'FORCE',
    'FOREIGN',
    'FORWARD',
    'FREEZE',
    'FROM',
    'FULL',
    'FUNCTION',
    'FUNCTIONS',
    'GENERATED',
    'GLOBAL',
    'GRANT',
    'GRANTED',
    'GREATEST',
    'GROUP',
    'GROUPING',
    'GROUPS',
    'HANDLER',
    'HAVING',
    'HEADER',
    'HOLD',
    'HOUR',
    'IDENTITY',
    'IF',
    'ILIKE',
    'IMMEDIATE',
    'IMMUTABLE',
    'IMPLICIT',
    'IMPORT',
    'IN',
    'INCLUDE',
    'INCLUDING',
    'INCREMENT',
    'INDEX',
    'INDEXES',
    'INHERIT',
    'INHERITS',
    'INITIALLY',
    'INLINE',
    'INNER',
    'INOUT',
    'INPUT',
    'INSENSITIVE',
    'INSERT',
    'INSTEAD',
    'INT',
    'INTEGER',
    'INTERSECT',
    'INTERVAL',
    'INTO',
    'INVOKER',
    'IS',
    'ISNULL',
    'ISOLATION',
    'JOIN',
    'KEY',
    'LABEL',
    'LANGUAGE',
    'LARGE',
    'LAST',
    'LATERAL',
    'LEADING',
    'LEAKPROOF',
    'LEAST',
    'LEFT',
    'LEVEL',
    'LIKE',
    'LIMIT',
    'LISTEN',
    'LOAD',
    'LOCAL',
    'LOCALTIME',
    'LOCALTIMESTAMP',
    'LOCATION',
    'LOCK',
    'LOCKED',
    'LOGGED',
    'MAPPING',
    'MATCH',
    'MATERIALIZED',
    'MAXVALUE',
    'METHOD',
    'MINUTE',
    'MINVALUE',
    'MODE',
    'MONTH',
    'MOVE',
    'NAME',
    'NAMES',
    'NATIONAL',
    'NATURAL',
    'NCHAR',
    'NEW',
    'NEXT',
    'NFC',
    'NFD',
    'NFKC',
    'NFKD',
    'NO',
    'NONE',
    'NORMALIZE',
    'NORMALIZED',
    'NOT',
    'NOTHING',
    'NOTIFY',
    'NOTNULL',
    'NOWAIT',
    'NULL',
    'NULLIF',
    'NULLS',
    'NUMERIC',
    'OBJECT',
    'OF',
    'OFF',
    'OFFSET',
    'OIDS',
    'OLD',
    'ON',
    'ONLY',
    'OPERATOR',
    'OPTION',
    'OPTIONS',
    'OR',
    'ORDER',
    'ORDINALITY',
    'OTHERS',
    'OUT',
    'OUTER',
    'OVER',
    'OVERLAPS',
    'OVERLAY',
    'OVERRIDING',
    'OWNED',
    'OWNER',
    'PARALLEL',
    'PARSER',
    'PARTIAL',
    'PARTITION',
    'PASSING',
    'PASSWORD',
    'PLACING',
    'PLANS',
    'POLICY',
    'POSITION',
    'PRECEDING',
    'PRECISION',
    'PREPARE',
    'PREPARED',
    'PRESERVE',
    'PRIMARY',
    'PRIOR',
    'PRIVILEGES',
    'PROCEDURAL',
    'PROCEDURE',
    'PROCEDURES',
    'PROGRAM',
    'PUBLICATION',
    'QUOTE',
    'RANGE',
    'READ',
    'REAL',
    'REASSIGN',
    'RECHECK',
    'RECURSIVE',
    'REF',
    'REFERENCES',
    'REFERENCING',
    'REFRESH',
    'REINDEX',
    'RELATIVE',
    'RELEASE',
    'RENAME',
    'REPEATABLE',
    'REPLACE',
    'REPLICA',
    'RESET',
    'RESTART',
    'RESTRICT',
    'RETURN',
    'RETURNING',
    'RETURNS',
    'REVOKE',
    'RIGHT',
    'ROLE',
    'ROLLBACK',
    'ROLLUP',
    'ROUTINE',
    'ROUTINES',
    'ROW',
    'ROWS',
    'RULE',
    'SAVEPOINT',
    'SCHEMA',
    'SCHEMAS',
    'SCROLL',
    'SEARCH',
    'SECOND',
    'SECURITY',
    'SELECT',
    'SEQUENCE',
    'SEQUENCES',
    'SERIALIZABLE',
    'SERVER',
    'SESSION',
    'SESSION_USER',
    'SET',
    'SETOF',
    'SETS',
    'SHARE',
    'SHOW',
    'SIMILAR',
    'SIMPLE',
    'SKIP',
    'SMALLINT',
    'SNAPSHOT',
    'SOME',
    'SQL',
    'STABLE',
    'STANDALONE',
    'START',
    'STATEMENT',
    'STATISTICS',
    'STDIN',
    'STDOUT',
    'STORAGE',
    'STORED',
    'STRICT',
    'STRIP',
    'SUBSCRIPTION',
    'SUBSTRING',
    'SUPPORT',
    'SYMMETRIC',
    'SYSID',
    'SYSTEM',
    'TABLE',
    'TABLES',
    'TABLESAMPLE',
    'TABLESPACE',
    'TEMP',
    'TEMPLATE',
    'TEMPORARY',
    'TEXT',
    'THEN',
    'TIES',
    'TIME',
    'TIMESTAMP',
    'TO',
    'TRAILING',
    'TRANSACTION',
    'TRANSFORM',
    'TREAT',
    'TRIGGER',
    'TRIM',
    'TRUE',
    'TRUNCATE',
    'TRUSTED',
    'TYPE',
    'TYPES',
    'UESCAPE',
    'UNBOUNDED',
    'UNCOMMITTED',
    'UNENCRYPTED',
    'UNION',
    'UNIQUE',
    'UNKNOWN',
    'UNLISTEN',
    'UNLOGGED',
    'UNTIL',
    'UPDATE',
    'USER',
    'USING',
    'VACUUM',
    'VALID',
    'VALIDATE',
    'VALIDATOR',
    'VALUE',
    'VALUES',
    'VARCHAR',
    'VARIADIC',
    'VARYING',
    'VERBOSE',
    'VERSION',
    'VIEW',
    'VIEWS',
    'VOLATILE',
    'WHEN',
    'WHERE',
    'WHITESPACE',
    'WINDOW',
    'WITH',
    'WITHIN',
    'WITHOUT',
    'WORK',
    'WRAPPER',
    'WRITE',
    'XML',
    'XMLATTRIBUTES',
    'XMLCONCAT',
    'XMLELEMENT',
    'XMLEXISTS',
    'XMLFOREST',
    'XMLNAMESPACES',
    'XMLPARSE',
    'XMLPI',
    'XMLROOT',
    'XMLSERIALIZE',
    'XMLTABLE',
    'YEAR',
    'YES',
    'ZONE',
)

DATATYPES = (
    'bigint',
    'bigserial',
    'bit',
    'bit varying',
    'bool',
    'boolean',
    'box',
    'bytea',
    'char',
    'character',
    'character varying',
    'cidr',
    'circle',
    'date',
    'decimal',
    'double precision',
    'float4',
    'float8',
    'inet',
    'int',
    'int2',
    'int4',
    'int8',
    'integer',
    'interval',
    'json',
    'jsonb',
    'line',
    'lseg',
    'macaddr',
    'macaddr8',
    'money',
    'numeric',
    'path',
    'pg_lsn',
    'pg_snapshot',
    'point',
    'polygon',
    'real',
    'serial',
    'serial2',
    'serial4',
    'serial8',
    'smallint',
    'smallserial',
    'text',
    'time',
    'timestamp',
    'timestamptz',
    'timetz',
    'tsquery',
    'tsvector',
    'txid_snapshot',
    'uuid',
    'varbit',
    'varchar',
    'with time zone',
    'without time zone',
    'xml',
)

PSEUDO_TYPES = (
    'any',
    'anyarray',
    'anycompatible',
    'anycompatiblearray',
    'anycompatiblemultirange',
    'anycompatiblenonarray',
    'anycompatiblerange',
    'anyelement',
    'anyenum',
    'anymultirange',
    'anynonarray',
    'anyrange',
    'cstring',
    'event_trigger',
    'fdw_handler',
    'index_am_handler',
    'internal',
    'language_handler',
    'pg_ddl_command',
    'record',
    'table_am_handler',
    'trigger',
    'tsm_handler',
    'unknown',
    'void',
)

# Remove 'trigger' from types
PSEUDO_TYPES = tuple(sorted(set(PSEUDO_TYPES) - set(map(str.lower, KEYWORDS))))

PLPGSQL_KEYWORDS = (
    'ALIAS', 'CONSTANT', 'DIAGNOSTICS', 'ELSIF', 'EXCEPTION', 'EXIT',
    'FOREACH', 'GET', 'LOOP', 'NOTICE', 'OPEN', 'PERFORM', 'QUERY', 'RAISE',
    'RETURN', 'REVERSE', 'SQLSTATE', 'WHILE',
)

# Most of these keywords are from ExplainNode function
# in src/backend/commands/explain.c

EXPLAIN_KEYWORDS = (
    'Aggregate',
    'Append',
    'Bitmap Heap Scan',
    'Bitmap Index Scan',
    'BitmapAnd',
    'BitmapOr',
    'CTE Scan',
    'Custom Scan',
    'Delete',
    'Foreign Scan',
    'Function Scan',
    'Gather Merge',
    'Gather',
    'Group',
    'GroupAggregate',
    'Hash Join',
    'Hash',
    'HashAggregate',
    'Incremental Sort',
    'Index Only Scan',
    'Index Scan',
    'Insert',
    'Limit',
    'LockRows',
    'Materialize',
    'Memoize',
    'Merge Append',
    'Merge Join',
    'Merge',
    'MixedAggregate',
    'Named Tuplestore Scan',
    'Nested Loop',
    'ProjectSet',
    'Recursive Union',
    'Result',
    'Sample Scan',
    'Seq Scan',
    'SetOp',
    'Sort',
    'SubPlan',
    'Subquery Scan',
    'Table Function Scan',
    'Tid Range Scan',
    'Tid Scan',
    'Unique',
    'Update',
    'Values Scan',
    'WindowAgg',
    'WorkTable Scan',
)

if __name__ == '__main__':  # pragma: no cover
    import re
    from urllib.request import urlopen

from pygments.util import format_lines

# One man's constant is another man's variable.
    SOURCE_URL = 'https://github.com/postgres/postgres/raw/master'
    KEYWORDS_URL = SOURCE_URL + '/src/include/parser/kwlist.h'
    DATATYPES_URL = SOURCE_URL + '/doc/src/sgml/datatype.sgml'

def update_myself():
        content = urlopen(DATATYPES_URL).read().decode('utf-8', errors='ignore')
        data_file = list(content.splitlines())
        datatypes = parse_datatypes(data_file)
        pseudos = parse_pseudos(data_file)

content = urlopen(KEYWORDS_URL).read().decode('utf-8', errors='ignore')
        keywords = parse_keywords(content)

update_consts(__file__, 'DATATYPES', datatypes)
        update_consts(__file__, 'PSEUDO_TYPES', pseudos)
        update_consts(__file__, 'KEYWORDS', keywords)

def parse_keywords(f):
        kw = []
        for m in re.finditer(r'PG_KEYWORD\("(.+?)"', f):
            kw.append(m.group(1).upper())

if not kw:
            raise ValueError('no keyword found')

kw.sort()
        return kw

def parse_datatypes(f):
        dt = set()
        for line in f:
            if '<sect1' in line:
                break
            if '<entry><type>' not in line:
                continue

# Parse a string such as
            # time [ (<replaceable>p</replaceable>) ] [ without time zone ]
            # into types "time" and "without time zone"

# remove all the tags
            line = re.sub("<replaceable>[^<]+</replaceable>", "", line)
            line = re.sub("<[^>]+>", "", line)

# Drop the parts containing braces
            for tmp in [t for tmp in line.split('[')
                        for t in tmp.split(']') if "(" not in t]:
                for t in tmp.split(','):
                    t = t.strip()
                    if not t: continue
                    dt.add(" ".join(t.split()))

dt = list(dt)
        dt.sort()
        return dt

def parse_pseudos(f):
        dt = []
        re_start = re.compile(r'\s*<table id="datatype-pseudotypes-table">')
        re_entry = re.compile(r'\s*<entry><type>(.+?)</type></entry>')
        re_end = re.compile(r'\s*</table>')

f = iter(f)
        for line in f:
            if re_start.match(line) is not None:
                break
        else:
            raise ValueError('pseudo datatypes table not found')

for line in f:
            m = re_entry.match(line)
            if m is not None:
                dt.append(m.group(1))

if re_end.match(line) is not None:
                break
        else:
            raise ValueError('end of pseudo datatypes table not found')

if not dt:
            raise ValueError('pseudo datatypes not found')

dt.sort()
        return dt

def update_consts(filename, constname, content):
        with open(filename, encoding='utf-8') as f:
            data = f.read()

# Line to start/end inserting
        re_match = re.compile(r'^%s\s*=\s*$$.*?^\s*$$' % constname, re.M | re.S)
        m = re_match.search(data)
        if not m:
            raise ValueError('Could not find existing definition for %s' %
                             (constname,))

new_block = format_lines(constname, content)
        data = data[:m.start()] + new_block + data[m.end():]

with open(filename, 'w', encoding='utf-8', newline='\n') as f:
            f.write(data)

update_myself()