questdb-keywords.txt

account
accounts
add
align
all
alter
and
any
as
asc
asof
assume
attach
atomic
backup
base
between
by
cache
calendar
capacity
cascade
case
cast
cancel
column
columns
complete
copy
create
cross
current
dedup
database
declare
detach
details
default
delete
disable
desc
distinct
drop
else
enable
end
except
exclude
exists
exit
explain
fill
first
for
foreign
following
from
full
grant
group
groups
header
http
if
ignore
ilp
in
include
incremental
index
inner
insert
intersect
into
isolation
join
jwk
key
keys
latest
left
level
limit
list
lock
lt
materialized
nan
natural
no
nocache
none
not
null
nulls
observation
offset
on
only
or
order
others
outer
over
owned
param
partition
partitions
password
permissions
pgwire
pivot
preceding
prepare
primary
public
range
references
refresh
reindex
remove
rename
repair
respect
rest
resume
revoke
right
range
row
rows
sample
select
set
service
show
snapshot
splice
squash
system
table
tables
then
time
to
token
transaction
truncate
ttl
txn
type
unbounded
union
unlock
unpivot
update
user
users
upsert
vacuum
values
view
wal
when
where
with
writer
zone
<<
<<=
>>
>>=
VARCHAR
abs
acos
all_permissions
all_tables
and
approx_percentile
asin
atan
atan2
avg
base64
batch
between
build
case
cast
ceil
ceiling
coalesce
commitLag
concat
cos
cot
count
count_distinct
current_database
current_schema
current_schemas
current_user
date_trunc
dateadd
datediff
day
day_of_week
day_of_week_sunday_first
days_in_month
degrees
dump_memory_usage
dump_thread_stacks
extract
first
first_value
floor
flush_query_cache
format
format_type
functions
haversine_dist_deg
headers
hour
ifnull
ilike
in
information_schema._pg_expandarray
isOrdered
is_leap_year
isnull
keywords
ksum
lag
last
lcase
lead
left
len
length
like
list
ln
log
long_sequence
lower
lpad
ltrim
make_geohash
materialized_views
max
maxUncommittedRows
memory_metrics
micros
mid
millis
min
minute
month
netmask
not
now
nsum
nullif
nvl
or
permissions
pg_advisory_unlock_all
pg_attrdef
pg_attribute
pg_catalog.age
pg_catalog.current_database
pg_catalog.current_schema
pg_catalog.current_schemas
pg_catalog.pg_attrdef
pg_catalog.pg_attribute
pg_catalog.pg_class
pg_catalog.pg_database
pg_catalog.pg_description
pg_catalog.pg_get_expr
pg_catalog.pg_get_keywords
pg_catalog.pg_get_partkeydef
pg_catalog.pg_get_userbyid
pg_catalog.pg_index
pg_catalog.pg_inherits
pg_catalog.pg_is_in_recovery
pg_catalog.pg_locks
pg_catalog.pg_namespace
pg_catalog.pg_roles
pg_catalog.pg_shdescription
pg_catalog.pg_table_is_visible
pg_catalog.pg_type
pg_catalog.txid_current
pg_catalog.version
pg_class
pg_database
pg_description
pg_get_expr
pg_get_keywords
pg_get_partkeydef
pg_index
pg_inherits
pg_is_in_recovery
pg_locks
pg_namespace
pg_postmaster_start_time
pg_proc
pg_range
pg_roles
pg_type
pi
position
power
radians
rank
reader_pool
regexp_replace
reload_tls
replace
right
rnd_bin
rnd_boolean
rnd_byte
rnd_char
rnd_date
rnd_double
rnd_float
rnd_geohash
rnd_int
rnd_ipv4
rnd_log
rnd_long
rnd_long256
rnd_short
rnd_str
rnd_symbol
rnd_timestamp
rnd_uuid4
rnd_varchar
round
round_down
round_half_even
round_up
row_number
rpad
rtrim
second
server_conf
server_version
session_user
show
simulate_crash
sin
size_pretty
split_part
sqrt
starts_with
stddev
stddev_pop
stddev_samp
string_agg
strpos
substring
sum
switch
sysdate
systimestamp
table_columns
table_partitions
table_writer_metrics
tables
tan
timestamp_ceil
timestamp_floor
timestamp_sequence
timestamp_shuffle
to_char
to_date
to_long128
to_lowercase
to_pg_date
to_str
to_timestamp
to_timezone
to_uppercase
to_utc
to_uuid
touch
trim
txid_current
typeOf
ucase
upper
var_pop
var_samp
variance
version
wal_tables
week_of_year
within
vwap
year
false
true
binary
boolean
byte
char
date
double
float
geohash
int
interval
ipv4
long
long128
long256
short
string
symbol
timestamp
uuid