stmt_block:
stmt_list no references
stmt_list:
stmt ; referenced by:
stmt:
HELPTOKEN alter_stmt backup_stmt cancel_stmt copy_from_stmt create_stmt deallocate_stmt delete_stmt discard_stmt drop_stmt execute_stmt explain_stmt export_stmt grant_stmt insert_stmt import_stmt pause_stmt prepare_stmt restore_stmt resume_stmt revoke_stmt savepoint_stmt scrub_stmt select_stmt release_stmt reset_stmt set_stmt show_stmt transaction_stmt truncate_stmt update_stmt upsert_stmt referenced by:
alter_stmt:
alter_ddl_stmt alter_user_stmt referenced by:
backup_stmt:
BACKUP targets TO string_or_placeholder opt_as_of_clause opt_incremental opt_with_options referenced by:
cancel_stmt:
cancel_job_stmt cancel_query_stmt cancel_session_stmt referenced by:
copy_from_stmt:
COPY table_name opt_column_list FROM STDIN referenced by:
create_stmt:
create_user_stmt create_role_stmt create_ddl_stmt create_stats_stmt referenced by:
deallocate_stmt:
DEALLOCATE PREPARE name ALL referenced by:
delete_stmt:
opt_with_clause DELETE FROM relation_expr_opt_alias where_clause opt_sort_clause opt_limit_clause returning_clause referenced by:
discard_stmt:
DISCARD ALL referenced by:
drop_stmt:
drop_ddl_stmt drop_role_stmt drop_user_stmt referenced by:
execute_stmt:
EXECUTE table_alias_name execute_param_clause referenced by:
explain_stmt:
EXPLAIN ( explain_option_list ) explainable_stmt referenced by:
export_stmt:
EXPORT INTO CSV string_or_placeholder opt_with_options FROM select_stmt referenced by:
grant_stmt:
GRANT privileges ON targets TO name_list privilege_list TO name_list WITH ADMIN OPTION referenced by:
insert_stmt:
opt_with_clause INSERT INTO insert_target insert_rest on_conflict returning_clause referenced by:
import_stmt:
IMPORT TABLE table_name CREATE USING string_or_placeholder ( table_elem_list ) CSV DATA ( string_or_placeholder_list ) opt_with_options referenced by:
pause_stmt:
PAUSE JOB a_expr referenced by:
prepare_stmt:
PREPARE table_alias_name prep_type_clause AS preparable_stmt referenced by:
restore_stmt:
RESTORE targets FROM string_or_placeholder_list as_of_clause opt_with_options referenced by:
resume_stmt:
RESUME JOB a_expr referenced by:
revoke_stmt:
REVOKE privileges ON targets ADMIN OPTION FOR privilege_list FROM name_list referenced by:
savepoint_stmt:
SAVEPOINT name referenced by:
scrub_stmt:
scrub_table_stmt scrub_database_stmt referenced by:
select_stmt:
select_no_parens select_with_parens referenced by:
release_stmt:
RELEASE savepoint_name referenced by:
reset_stmt:
reset_session_stmt reset_csetting_stmt referenced by:
set_stmt:
set_session_stmt set_csetting_stmt set_transaction_stmt use_stmt referenced by:
show_stmt:
show_backup_stmt show_columns_stmt show_constraints_stmt show_create_table_stmt show_create_view_stmt show_create_sequence_stmt show_csettings_stmt show_databases_stmt show_grants_stmt show_histogram_stmt show_indexes_stmt show_jobs_stmt show_queries_stmt show_ranges_stmt show_roles_stmt show_schemas_stmt show_session_stmt show_sessions_stmt show_stats_stmt show_tables_stmt show_trace_stmt show_users_stmt referenced by:
transaction_stmt:
begin_stmt commit_stmt rollback_stmt abort_stmt referenced by:
truncate_stmt:
TRUNCATE opt_table relation_expr_list opt_drop_behavior referenced by:
update_stmt:
opt_with_clause UPDATE relation_expr_opt_alias SET set_clause_list where_clause opt_sort_clause opt_limit_clause returning_clause referenced by:
upsert_stmt:
opt_with_clause UPSERT INTO insert_target insert_rest returning_clause referenced by:
alter_ddl_stmt:
alter_table_stmt alter_index_stmt alter_view_stmt alter_sequence_stmt alter_database_stmt referenced by:
alter_user_stmt:
alter_user_password_stmt referenced by:
targets:
identifier col_name_keyword unreserved_keyword complex_table_pattern table_pattern , TABLE table_pattern_list DATABASE name_list referenced by:
string_or_placeholder:
non_reserved_word_or_sconst PLACEHOLDER referenced by:
opt_as_of_clause:
as_of_clause referenced by:
opt_incremental:
INCREMENTAL FROM string_or_placeholder_list referenced by:
opt_with_options:
WITH kv_option_list OPTIONS ( kv_option_list ) referenced by:
cancel_job_stmt:
CANCEL JOB a_expr referenced by:
cancel_query_stmt:
CANCEL QUERY IF EXISTS a_expr referenced by:
cancel_session_stmt:
CANCEL SESSION IF EXISTS a_expr referenced by:
table_name:
db_object_name referenced by:
opt_column_list:
( name_list ) referenced by:
create_user_stmt:
CREATE USER IF NOT EXISTS string_or_placeholder opt_password referenced by:
create_role_stmt:
CREATE ROLE IF NOT EXISTS string_or_placeholder referenced by:
create_ddl_stmt:
create_database_stmt create_index_stmt create_table_stmt create_table_as_stmt create_view_stmt create_sequence_stmt referenced by:
create_stats_stmt:
CREATE STATISTICS statistics_name ON name_list FROM table_name referenced by:
name:
identifier unreserved_keyword col_name_keyword referenced by:
opt_with_clause:
with_clause referenced by:
relation_expr_opt_alias:
relation_expr AS table_alias_name referenced by:
where_clause:
WHERE a_expr referenced by:
opt_sort_clause:
sort_clause referenced by:
opt_limit_clause:
limit_clause referenced by:
returning_clause:
RETURNING target_list NOTHING referenced by:
drop_ddl_stmt:
drop_database_stmt drop_index_stmt drop_table_stmt drop_view_stmt drop_sequence_stmt referenced by:
drop_role_stmt:
DROP ROLE IF EXISTS string_or_placeholder_list referenced by:
drop_user_stmt:
DROP USER IF EXISTS string_or_placeholder_list referenced by:
table_alias_name:
name referenced by:
execute_param_clause:
( expr_list ) referenced by:
explainable_stmt:
preparable_stmt alter_ddl_stmt create_ddl_stmt create_stats_stmt drop_ddl_stmt execute_stmt referenced by:
explain_option_list:
explain_option_name , referenced by:
privileges:
ALL privilege_list referenced by:
name_list:
name , referenced by:
privilege_list:
privilege , referenced by:
insert_target:
table_name AS table_alias_name referenced by:
insert_rest:
( insert_column_list ) select_stmt DEFAULT VALUES referenced by:
on_conflict:
ON CONFLICT opt_conf_expr DO UPDATE SET set_clause_list where_clause NOTHING referenced by:
string_or_placeholder_list:
string_or_placeholder , referenced by:
table_elem_list:
table_elem , referenced by:
a_expr:
c_expr + - ~ NOT a_expr DEFAULT MAXVALUE MINVALUE TYPECAST cast_target TYPEANNOTATE typename COLLATE collation_name + a_expr - a_expr * a_expr / a_expr FLOORDIV a_expr % a_expr ^ a_expr # a_expr & a_expr | a_expr < a_expr > a_expr ? a_expr JSON_SOME_EXISTS a_expr JSON_ALL_EXISTS a_expr CONTAINS a_expr CONTAINED_BY a_expr = a_expr CONCAT a_expr LSHIFT a_expr RSHIFT a_expr FETCHVAL a_expr FETCHTEXT a_expr FETCHVAL_PATH a_expr FETCHTEXT_PATH a_expr REMOVE_PATH a_expr INET_CONTAINED_BY_OR_EQUALS a_expr INET_CONTAINS_OR_CONTAINED_BY a_expr INET_CONTAINS_OR_EQUALS a_expr LESS_EQUALS a_expr GREATER_EQUALS a_expr NOT_EQUALS a_expr AND a_expr OR a_expr LIKE a_expr NOT LIKE a_expr ILIKE a_expr NOT ILIKE a_expr SIMILAR TO a_expr NOT SIMILAR TO a_expr ~ a_expr NOT_REGMATCH a_expr REGIMATCH a_expr NOT_REGIMATCH a_expr IS NAN IS NOT NAN IS NULL ISNULL IS NOT NULL NOTNULL IS TRUE IS NOT TRUE IS FALSE IS NOT FALSE IS UNKNOWN IS NOT UNKNOWN IS DISTINCT FROM a_expr IS NOT DISTINCT FROM a_expr IS OF ( type_list ) IS NOT OF ( type_list ) BETWEEN opt_asymmetric b_expr AND a_expr NOT BETWEEN opt_asymmetric b_expr AND a_expr BETWEEN SYMMETRIC b_expr AND a_expr NOT BETWEEN SYMMETRIC b_expr AND a_expr IN in_expr NOT IN in_expr subquery_op sub_type a_expr referenced by:
prep_type_clause:
( type_list ) referenced by:
preparable_stmt:
alter_user_stmt backup_stmt cancel_stmt create_user_stmt create_role_stmt delete_stmt drop_role_stmt drop_user_stmt import_stmt insert_stmt pause_stmt reset_stmt restore_stmt resume_stmt select_stmt set_session_stmt set_csetting_stmt show_stmt update_stmt upsert_stmt referenced by:
as_of_clause:
AS OF SYSTEM TIME a_expr_const referenced by:
scrub_table_stmt:
EXPERIMENTAL SCRUB TABLE table_name opt_as_of_clause opt_scrub_options_clause referenced by:
scrub_database_stmt:
EXPERIMENTAL SCRUB DATABASE database_name opt_as_of_clause referenced by:
select_no_parens:
simple_select select_clause sort_clause opt_sort_clause select_limit with_clause select_clause sort_clause opt_sort_clause select_limit referenced by:
select_with_parens:
( select_no_parens select_with_parens ) referenced by:
savepoint_name:
SAVEPOINT name referenced by:
reset_session_stmt:
RESET SESSION session_var referenced by:
reset_csetting_stmt:
RESET CLUSTER SETTING var_name referenced by:
set_session_stmt:
SET SESSION set_rest_more CHARACTERISTICS AS TRANSACTION transaction_mode_list set_rest_more referenced by:
set_csetting_stmt:
SET CLUSTER SETTING var_name = TO var_value referenced by:
set_transaction_stmt:
SET SESSION TRANSACTION transaction_mode_list referenced by:
use_stmt:
USE var_value referenced by:
show_backup_stmt:
SHOW BACKUP string_or_placeholder referenced by:
show_columns_stmt:
SHOW COLUMNS FROM table_name referenced by:
show_constraints_stmt:
SHOW CONSTRAINT CONSTRAINTS FROM table_name referenced by:
show_create_table_stmt:
SHOW CREATE TABLE table_name referenced by:
show_create_view_stmt:
SHOW CREATE VIEW view_name referenced by:
show_create_sequence_stmt:
SHOW CREATE SEQUENCE sequence_name referenced by:
show_csettings_stmt:
SHOW CLUSTER SETTING var_name ALL ALL CLUSTER SETTINGS referenced by:
show_databases_stmt:
SHOW DATABASES referenced by:
show_grants_stmt:
SHOW GRANTS opt_on_targets_roles for_grantee_clause referenced by:
show_histogram_stmt:
SHOW HISTOGRAM ICONST referenced by:
show_indexes_stmt:
SHOW INDEX INDEXES KEYS FROM table_name referenced by:
show_jobs_stmt:
SHOW JOBS referenced by:
show_queries_stmt:
SHOW CLUSTER LOCAL QUERIES referenced by:
show_ranges_stmt:
SHOW ranges_kw FROM TABLE table_name INDEX table_name_with_index referenced by:
show_roles_stmt:
SHOW ROLES referenced by:
show_schemas_stmt:
SHOW SCHEMAS FROM name referenced by:
show_session_stmt:
SHOW SESSION session_var referenced by:
show_sessions_stmt:
SHOW CLUSTER LOCAL SESSIONS referenced by:
show_stats_stmt:
SHOW STATISTICS USING JSON FOR TABLE table_name referenced by:
show_tables_stmt:
SHOW TABLES FROM name . name referenced by:
show_trace_stmt:
SHOW opt_compact KV TRACE FOR SESSION explainable_stmt referenced by:
show_users_stmt:
SHOW USERS referenced by:
begin_stmt:
BEGIN opt_transaction START TRANSACTION begin_transaction referenced by:
commit_stmt:
COMMIT END opt_transaction referenced by:
rollback_stmt:
ROLLBACK opt_to_savepoint referenced by:
abort_stmt:
ABORT opt_abort_mod referenced by:
opt_table:
TABLE referenced by:
relation_expr_list:
relation_expr , referenced by:
opt_drop_behavior:
CASCADE RESTRICT referenced by:
set_clause_list:
set_clause , referenced by:
alter_table_stmt:
alter_onetable_stmt alter_split_stmt alter_scatter_stmt alter_rename_table_stmt referenced by:
alter_index_stmt:
alter_oneindex_stmt alter_split_index_stmt alter_scatter_index_stmt alter_rename_index_stmt referenced by:
alter_view_stmt:
alter_rename_view_stmt referenced by:
alter_sequence_stmt:
alter_rename_sequence_stmt alter_sequence_options_stmt referenced by:
alter_database_stmt:
alter_rename_database_stmt referenced by:
alter_user_password_stmt:
ALTER USER IF EXISTS string_or_placeholder WITH PASSWORD string_or_placeholder referenced by:
col_name_keyword:
ANNOTATE_TYPE BETWEEN BIGINT BIT BOOLEAN CHAR CHARACTER CHARACTERISTICS COALESCE DEC DECIMAL EXISTS EXTRACT EXTRACT_DURATION FLOAT GREATEST GROUPING IF IFNULL INT INTEGER INTERVAL LEAST NULLIF NUMERIC OUT OVERLAY POSITION PRECISION REAL ROW SMALLINT SUBSTRING TIME TIMESTAMP TREAT TRIM VALUES VARCHAR VIRTUAL WORK referenced by:
unreserved_keyword:
ABORT ACTION ADD ADMIN ALTER AT BACKUP BEGIN BIGSERIAL BLOB BOOL BY BYTEA BYTES CACHE CANCEL CASCADE CLUSTER COLUMNS COMMENT COMMIT COMMITTED COMPACT CONFLICT CONFIGURATION CONFIGURATIONS CONFIGURE CONSTRAINTS COPY COVERING CSV CUBE CURRENT CYCLE DATA DATABASE DATABASES DATE DAY DEALLOCATE DELETE DISCARD DOUBLE DROP EMIT ENCODING EXECUTE EXPERIMENTAL EXPERIMENTAL_AUDIT EXPERIMENTAL_CHANGEFEED EXPERIMENTAL_FINGERPRINTS EXPERIMENTAL_RANGES EXPERIMENTAL_RELOCATE EXPERIMENTAL_REPLICA EXPLAIN EXPORT FILTER FIRST FLOAT4 FLOAT8 FOLLOWING FORCE_INDEX GIN GRANTS HIGH HISTOGRAM HOUR IMPORT INCREMENT INCREMENTAL INDEXES INET INJECT INSERT INT2 INT2VECTOR INT4 INT8 INT64 INTERLEAVE INVERTED ISOLATION JOB JOBS JSON JSONB KEY KEYS KV LC_COLLATE LC_CTYPE LESS LEVEL LIST LOCAL LOW MATCH MINUTE MONTH NAMES NAN NAME NEXT NO NORMAL NO_INDEX_JOIN NULLS OF OFF OID OIDVECTOR OPTION OPTIONS ORDINALITY OVER OWNED PARENT PARTIAL PARTITION PASSWORD PAUSE PHYSICAL PLANS PRECEDING PREPARE PRIORITY QUERIES QUERY RANGE READ RECURSIVE REF REGCLASS REGPROC REGPROCEDURE REGNAMESPACE REGTYPE RELEASE RENAME REPEATABLE RESET RESTORE RESTRICT RESUME REVOKE ROLE ROLES ROLLBACK ROLLUP ROWS SETTING SETTINGS STATUS SAVEPOINT SCATTER SCHEMA SCHEMAS SCRUB SEARCH SECOND SERIAL SERIALIZABLE SERIAL2 SERIAL4 SERIAL8 SEQUENCE SEQUENCES SESSION SESSIONS SET SHOW SIMPLE SMALLSERIAL SNAPSHOT SQL START STATISTICS STDIN STORE STORING STRICT STRING SPLIT SYNTAX SYSTEM TABLES TEMP TEMPLATE TEMPORARY TESTING_RANGES TESTING_RELOCATE TEXT THAN TIMESTAMPTZ TRACE TRANSACTION TRUNCATE TYPE UNBOUNDED UNCOMMITTED UNKNOWN UPDATE UPSERT UUID USE USERS VALID VALIDATE VALUE VARYING WITHIN WITHOUT WRITE YEAR ZONE referenced by:
complex_table_pattern:
complex_db_object_name name . unrestricted_name . * referenced by:
table_pattern:
simple_db_object_name complex_table_pattern referenced by:
table_pattern_list:
table_pattern , referenced by:
non_reserved_word_or_sconst:
non_reserved_word SCONST referenced by:
kv_option_list:
kv_option , referenced by:
db_object_name:
simple_db_object_name complex_db_object_name referenced by:
opt_password:
opt_with PASSWORD string_or_placeholder referenced by:
create_database_stmt:
CREATE DATABASE IF NOT EXISTS database_name opt_with opt_template_clause opt_encoding_clause opt_lc_collate_clause opt_lc_ctype_clause referenced by:
create_index_stmt:
CREATE opt_unique INDEX opt_index_name IF NOT EXISTS index_name ON table_name opt_using_gin ( index_params ) opt_storing opt_interleave opt_partition_by INVERTED INDEX opt_index_name IF NOT EXISTS index_name ON table_name ( index_params ) referenced by:
create_table_stmt:
CREATE TABLE IF NOT EXISTS table_name ( opt_table_elem_list ) opt_interleave opt_partition_by referenced by:
create_table_as_stmt:
CREATE TABLE IF NOT EXISTS table_name opt_column_list AS select_stmt referenced by:
create_view_stmt:
CREATE VIEW view_name opt_column_list AS select_stmt referenced by:
create_sequence_stmt:
CREATE SEQUENCE IF NOT EXISTS sequence_name opt_sequence_option_list referenced by:
statistics_name:
name referenced by:
with_clause:
WITH cte_list referenced by:
relation_expr:
table_name * ONLY table_name ( table_name ) referenced by:
sort_clause:
ORDER BY sortby_list referenced by:
limit_clause:
LIMIT select_limit_value FETCH first_or_next opt_select_fetch_first_value row_or_rows ONLY referenced by:
target_list:
target_elem , referenced by:
drop_database_stmt:
DROP DATABASE IF EXISTS database_name opt_drop_behavior referenced by:
drop_index_stmt:
DROP INDEX IF EXISTS table_name_with_index_list opt_drop_behavior referenced by:
drop_table_stmt:
DROP TABLE IF EXISTS table_name_list opt_drop_behavior referenced by:
drop_view_stmt:
DROP VIEW IF EXISTS table_name_list opt_drop_behavior referenced by:
drop_sequence_stmt:
DROP SEQUENCE IF EXISTS table_name_list opt_drop_behavior referenced by:
expr_list:
a_expr , referenced by:
explain_option_name:
non_reserved_word referenced by:
privilege:
name CREATE GRANT SELECT referenced by:
insert_column_list:
insert_column_item , referenced by:
opt_conf_expr:
( name_list ) where_clause referenced by:
table_elem:
column_def index_def family_def table_constraint referenced by:
c_expr:
d_expr array_subscripts case_expr EXISTS select_with_parens referenced by:
cast_target:
typename postgres_oid referenced by:
typename:
simple_typename opt_array_bounds ARRAY referenced by:
collation_name:
unrestricted_name referenced by:
type_list:
typename , referenced by:
opt_asymmetric:
ASYMMETRIC referenced by:
b_expr:
c_expr + - ~ b_expr TYPECAST cast_target TYPEANNOTATE typename + - * / FLOORDIV % ^ # & | < > = CONCAT LSHIFT RSHIFT LESS_EQUALS GREATER_EQUALS NOT_EQUALS b_expr IS NOT DISTINCT FROM b_expr OF ( type_list ) referenced by:
in_expr:
select_with_parens ( expr_list ) referenced by:
subquery_op:
math_op NOT LIKE ILIKE referenced by:
sub_type:
ANY SOME ALL referenced by:
a_expr_const:
ICONST FCONST const_typename SCONST BCONST interval TRUE FALSE NULL referenced by:
opt_scrub_options_clause:
WITH OPTIONS scrub_option_list referenced by:
database_name:
name referenced by:
simple_select:
simple_select_clause values_clause table_clause set_operation referenced by:
select_clause:
simple_select select_with_parens referenced by:
select_limit:
limit_clause offset_clause offset_clause limit_clause referenced by:
session_var:
identifier ALL DATABASE NAMES SESSION_USER TIME ZONE referenced by:
var_name:
name attrs referenced by:
set_rest_more:
generic_set referenced by:
transaction_mode_list:
transaction_mode opt_comma referenced by:
var_value:
a_expr ON referenced by:
view_name:
table_name referenced by:
sequence_name:
db_object_name referenced by:
opt_on_targets_roles:
ON targets_roles referenced by:
for_grantee_clause:
FOR name_list referenced by:
ranges_kw:
TESTING_RANGES EXPERIMENTAL_RANGES referenced by:
table_name_with_index:
table_name @ index_name referenced by:
opt_compact:
COMPACT referenced by:
opt_transaction:
TRANSACTION referenced by:
begin_transaction:
transaction_mode_list referenced by:
opt_to_savepoint:
TRANSACTION TO savepoint_name referenced by:
opt_abort_mod:
TRANSACTION WORK referenced by:
set_clause:
single_set_clause multiple_set_clause referenced by:
alter_onetable_stmt:
ALTER TABLE IF EXISTS relation_expr alter_table_cmds referenced by:
alter_split_stmt:
ALTER TABLE table_name SPLIT AT select_stmt referenced by:
alter_scatter_stmt:
ALTER TABLE table_name SCATTER FROM ( expr_list ) TO ( expr_list ) referenced by:
alter_rename_table_stmt:
ALTER TABLE IF EXISTS relation_expr RENAME TO table_name opt_column column_name TO column_name referenced by:
alter_oneindex_stmt:
ALTER INDEX IF EXISTS table_name_with_index alter_index_cmds referenced by:
alter_split_index_stmt:
ALTER INDEX table_name_with_index SPLIT AT select_stmt referenced by:
alter_scatter_index_stmt:
ALTER INDEX table_name_with_index SCATTER FROM ( expr_list ) TO ( expr_list ) referenced by:
alter_rename_index_stmt:
ALTER INDEX IF EXISTS table_name_with_index RENAME TO index_name referenced by:
alter_rename_view_stmt:
ALTER VIEW IF EXISTS relation_expr RENAME TO view_name referenced by:
alter_rename_sequence_stmt:
ALTER SEQUENCE IF EXISTS relation_expr RENAME TO sequence_name referenced by:
alter_sequence_options_stmt:
ALTER SEQUENCE IF EXISTS sequence_name sequence_option_list referenced by:
alter_rename_database_stmt:
ALTER DATABASE database_name RENAME TO database_name referenced by:
complex_db_object_name:
name . unrestricted_name . unrestricted_name referenced by:
unrestricted_name:
identifier unreserved_keyword col_name_keyword type_func_name_keyword reserved_keyword referenced by:
simple_db_object_name:
name referenced by:
non_reserved_word:
identifier unreserved_keyword col_name_keyword type_func_name_keyword referenced by:
kv_option:
name SCONST = string_or_placeholder referenced by:
opt_with:
WITH referenced by:
opt_template_clause:
TEMPLATE opt_equal non_reserved_word_or_sconst referenced by:
opt_encoding_clause:
ENCODING opt_equal non_reserved_word_or_sconst referenced by:
opt_lc_collate_clause:
LC_COLLATE opt_equal non_reserved_word_or_sconst referenced by:
opt_lc_ctype_clause:
LC_CTYPE opt_equal non_reserved_word_or_sconst referenced by:
opt_unique:
UNIQUE referenced by:
opt_index_name:
opt_name referenced by:
opt_using_gin:
USING GIN referenced by:
index_params:
index_elem , referenced by:
opt_storing:
storing ( name_list ) referenced by:
opt_interleave:
INTERLEAVE IN PARENT table_name ( name_list ) referenced by:
opt_partition_by:
partition_by referenced by:
index_name:
unrestricted_name referenced by:
opt_table_elem_list:
table_elem_list referenced by:
opt_sequence_option_list:
sequence_option_list referenced by:
cte_list:
common_table_expr , referenced by:
sortby_list:
sortby , referenced by:
select_limit_value:
a_expr ALL referenced by:
first_or_next:
FIRST NEXT referenced by:
opt_select_fetch_first_value:
signed_iconst ( a_expr ) referenced by:
row_or_rows:
ROW ROWS referenced by:
target_elem:
a_expr AS target_name identifier * referenced by:
table_name_with_index_list:
table_name_with_index , referenced by:
table_name_list:
table_name , referenced by:
insert_column_item:
column_name referenced by:
column_def:
column_name typename col_qual_list referenced by:
index_def:
UNIQUE INDEX opt_index_name ( index_params ) opt_storing opt_interleave opt_partition_by INVERTED INDEX opt_name ( index_params ) referenced by:
family_def:
FAMILY opt_family_name ( name_list ) referenced by:
table_constraint:
CONSTRAINT constraint_name constraint_elem referenced by:
d_expr:
column_path_with_star a_expr_const @ ICONST PLACEHOLDER ( a_expr ) func_expr select_with_parens ARRAY select_with_parens array_expr explicit_row implicit_row referenced by:
array_subscripts:
array_subscript referenced by:
case_expr:
CASE case_arg when_clause_list case_default END referenced by:
postgres_oid:
REGPROC REGPROCEDURE REGCLASS REGTYPE REGNAMESPACE referenced by:
simple_typename:
const_typename bit_with_length character_with_length INTERVAL opt_interval referenced by:
opt_array_bounds:
[ ] referenced by:
math_op:
+ - * / FLOORDIV % & | ^ # < > = LESS_EQUALS GREATER_EQUALS NOT_EQUALS referenced by:
const_typename:
numeric bit_without_length character_without_length const_datetime const_json BLOB BYTES BYTEA TEXT NAME SERIAL SERIAL2 SERIAL4 SERIAL8 SMALLSERIAL UUID INET BIGSERIAL OID OIDVECTOR INT2VECTOR identifier referenced by:
interval:
INTERVAL SCONST opt_interval referenced by:
scrub_option_list:
scrub_option , referenced by:
simple_select_clause:
SELECT opt_all_clause DISTINCT distinct_on_clause target_list from_clause where_clause group_clause having_clause window_clause referenced by:
values_clause:
VALUES ( expr_list ) , referenced by:
table_clause:
TABLE table_ref referenced by:
set_operation:
select_clause UNION INTERSECT EXCEPT all_or_distinct select_clause referenced by:
offset_clause:
OFFSET a_expr c_expr row_or_rows referenced by:
attrs:
. unrestricted_name referenced by:
generic_set:
var_name TO = var_list referenced by:
transaction_mode:
transaction_iso_level transaction_user_priority transaction_read_mode referenced by:
opt_comma:
, referenced by:
targets_roles:
ROLE name_list targets referenced by:
single_set_clause:
column_name = a_expr referenced by:
multiple_set_clause:
( insert_column_list ) = in_expr referenced by:
alter_table_cmds:
alter_table_cmd , referenced by:
opt_column:
COLUMN referenced by:
column_name:
name referenced by:
alter_index_cmds:
alter_index_cmd , referenced by:
sequence_option_list:
sequence_option_elem referenced by:
type_func_name_keyword:
COLLATION CROSS FAMILY FULL INNER ILIKE IS ISNULL JOIN LEFT LIKE MAXVALUE MINVALUE NATURAL NOTNULL OUTER OVERLAPS RIGHT SIMILAR referenced by:
reserved_keyword:
ALL ANALYSE ANALYZE AND ANY ARRAY AS ASC ASYMMETRIC BOTH CASE CAST CHECK COLLATE COLUMN CONSTRAINT CREATE CURRENT_CATALOG CURRENT_DATE CURRENT_ROLE CURRENT_SCHEMA CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER DEFAULT DEFERRABLE DESC DISTINCT DO ELSE END EXCEPT FALSE FETCH FOR FOREIGN FROM GRANT GROUP HAVING IN INDEX INITIALLY INTERSECT INTO LATERAL LEADING LIMIT LOCALTIME LOCALTIMESTAMP NOT NOTHING NULL OFFSET ON ONLY OR ORDER PLACING PRIMARY REFERENCES RETURNING SELECT SESSION_USER SOME STORED SYMMETRIC TABLE THEN TO TRAILING TRUE UNION UNIQUE USER USING VARIADIC VIEW WHEN WHERE WINDOW WITH referenced by:
opt_equal:
= referenced by:
opt_name:
name referenced by:
index_elem:
column_name opt_asc_desc referenced by:
storing:
COVERING STORING referenced by:
partition_by:
PARTITION BY LIST ( name_list ) ( list_partitions RANGE ( name_list ) ( range_partitions ) NOTHING referenced by:
common_table_expr:
table_alias_name opt_column_list AS ( preparable_stmt ) referenced by:
sortby:
a_expr PRIMARY KEY table_name INDEX table_name @ index_name opt_asc_desc referenced by:
signed_iconst:
+ - ICONST referenced by:
target_name:
unrestricted_name referenced by:
col_qual_list:
col_qualification referenced by:
opt_family_name:
opt_name referenced by:
constraint_name:
name referenced by:
constraint_elem:
CHECK ( a_expr PRIMARY KEY ( index_params ) UNIQUE ( index_params ) opt_storing opt_interleave opt_partition_by FOREIGN KEY ( name_list ) REFERENCES table_name opt_column_list reference_actions referenced by:
column_path_with_star:
column_path name . unrestricted_name . unrestricted_name . * referenced by:
func_expr:
func_application filter_clause over_clause func_expr_common_subexpr referenced by:
array_expr:
[ opt_expr_list array_expr_list ] referenced by:
explicit_row:
ROW ( opt_expr_list ) referenced by:
implicit_row:
( expr_list , a_expr ) referenced by:
array_subscript:
[ a_expr opt_slice_bound : opt_slice_bound ] referenced by:
case_arg:
a_expr referenced by:
when_clause_list:
when_clause referenced by:
case_default:
ELSE a_expr referenced by:
bit_with_length:
BIT opt_varying ( ICONST ) referenced by:
character_with_length:
character_base ( ICONST ) referenced by:
opt_interval:
YEAR TO MONTH MONTH DAY TO HOUR MINUTE SECOND HOUR TO MINUTE SECOND MINUTE TO SECOND SECOND referenced by:
numeric:
INT INT2 INT4 INT8 INT64 INTEGER SMALLINT BIGINT REAL FLOAT4 FLOAT8 FLOAT opt_float DOUBLE PRECISION DECIMAL DEC NUMERIC opt_numeric_modifiers BOOLEAN BOOL referenced by:
bit_without_length:
BIT opt_varying referenced by:
character_without_length:
character_base referenced by:
const_datetime:
DATE TIME WITHOUT TIME ZONE TIMESTAMP WITHOUT WITH TIME ZONE TIMESTAMPTZ referenced by:
const_json:
JSON JSONB referenced by:
scrub_option:
INDEX CONSTRAINT ALL ( name_list ) PHYSICAL referenced by:
opt_all_clause:
ALL referenced by:
from_clause:
FROM from_list opt_as_of_clause referenced by:
group_clause:
GROUP BY expr_list referenced by:
having_clause:
HAVING a_expr referenced by:
window_clause:
WINDOW window_definition_list referenced by:
distinct_on_clause:
DISTINCT ON ( expr_list ) referenced by:
table_ref:
relation_expr opt_index_hints func_name ( opt_expr_list ) special_function select_with_parens [ explainable_stmt ] opt_ordinality opt_alias_clause joined_table ( joined_table ) opt_ordinality alias_clause referenced by:
all_or_distinct:
ALL DISTINCT referenced by:
var_list:
var_value , referenced by:
transaction_iso_level:
ISOLATION LEVEL iso_level referenced by:
transaction_user_priority:
PRIORITY user_priority referenced by:
transaction_read_mode:
READ ONLY WRITE referenced by:
alter_table_cmd:
ADD COLUMN IF NOT EXISTS column_def table_constraint opt_validate_behavior ALTER opt_column column_name alter_column_default DROP NOT NULL DROP opt_column IF EXISTS column_name CONSTRAINT IF EXISTS constraint_name opt_drop_behavior VALIDATE CONSTRAINT constraint_name EXPERIMENTAL_AUDIT SET audit_mode partition_by INJECT STATISTICS a_expr referenced by:
alter_index_cmd:
partition_by referenced by:
sequence_option_elem:
NO CYCLE MINVALUE MAXVALUE INCREMENT BY MINVALUE MAXVALUE START WITH signed_iconst64 referenced by:
opt_asc_desc:
ASC DESC referenced by:
list_partitions:
list_partition , referenced by:
range_partitions:
range_partition , referenced by:
col_qualification:
CONSTRAINT constraint_name col_qualification_elem COLLATE collation_name FAMILY family_name CREATE FAMILY family_name IF NOT EXISTS FAMILY family_name referenced by:
reference_actions:
reference_on_update reference_on_delete reference_on_delete reference_on_update referenced by:
column_path:
name prefixed_column_path referenced by:
func_application:
func_name ( ALL DISTINCT expr_list opt_sort_clause * ) referenced by:
filter_clause:
FILTER ( WHERE a_expr ) referenced by:
over_clause:
OVER window_specification window_name referenced by:
func_expr_common_subexpr:
CURRENT_DATE CURRENT_SCHEMA CURRENT_CATALOG CURRENT_TIMESTAMP CURRENT_USER CURRENT_ROLE SESSION_USER USER CAST ( a_expr AS cast_target ANNOTATE_TYPE ( a_expr , typename IF ( a_expr , NULLIF IFNULL ( a_expr , a_expr COALESCE ( expr_list ) special_function referenced by:
opt_expr_list:
expr_list referenced by:
array_expr_list:
array_expr , referenced by:
opt_slice_bound:
a_expr referenced by:
when_clause:
WHEN a_expr THEN a_expr referenced by:
opt_varying:
VARYING referenced by:
character_base:
CHARACTER CHAR opt_varying VARCHAR STRING referenced by:
opt_float:
( ICONST ) referenced by:
opt_numeric_modifiers:
( ICONST , ICONST ) referenced by:
from_list:
table_ref , referenced by:
window_definition_list:
window_definition , referenced by:
opt_index_hints:
@ index_name [ ICONST ] { index_hints_param_list } referenced by:
opt_ordinality:
WITH ORDINALITY referenced by:
opt_alias_clause:
alias_clause referenced by:
func_name:
type_function_name prefixed_column_path referenced by:
special_function:
CURRENT_DATE CURRENT_SCHEMA CURRENT_TIMESTAMP CURRENT_USER ( EXTRACT EXTRACT_DURATION ( extract_list OVERLAY ( overlay_list POSITION ( position_list SUBSTRING ( substr_list GREATEST LEAST ( expr_list TRIM ( BOTH LEADING TRAILING trim_list ) referenced by:
joined_table:
( joined_table ) table_ref CROSS NATURAL join_type JOIN table_ref join_type JOIN table_ref join_qual referenced by:
alias_clause:
AS table_alias_name opt_column_list referenced by:
iso_level:
READ UNCOMMITTED COMMITTED SNAPSHOT REPEATABLE READ SERIALIZABLE referenced by:
user_priority:
LOW NORMAL HIGH referenced by:
alter_column_default:
SET DEFAULT a_expr DROP DEFAULT referenced by:
opt_validate_behavior:
NOT VALID referenced by:
audit_mode:
READ WRITE OFF referenced by:
signed_iconst64:
signed_iconst referenced by:
list_partition:
partition VALUES IN ( expr_list ) opt_partition_by referenced by:
range_partition:
partition VALUES FROM ( expr_list ) TO ( expr_list ) opt_partition_by referenced by:
col_qualification_elem:
NOT NULL UNIQUE PRIMARY KEY CHECK ( a_expr ) DEFAULT b_expr REFERENCES table_name opt_name_parens reference_actions AS ( a_expr ) STORED referenced by:
family_name:
name referenced by:
reference_on_update:
ON UPDATE reference_action referenced by:
reference_on_delete:
ON DELETE reference_action referenced by:
prefixed_column_path:
name . unrestricted_name . unrestricted_name . unrestricted_name referenced by:
window_specification:
( opt_existing_window_name opt_partition_clause opt_sort_clause ) referenced by:
window_name:
name referenced by:
window_definition:
window_name AS window_specification referenced by:
index_hints_param_list:
index_hints_param , referenced by:
type_function_name:
identifier unreserved_keyword type_func_name_keyword referenced by:
extract_list:
extract_arg FROM a_expr expr_list referenced by:
overlay_list:
a_expr overlay_placing substr_from substr_for expr_list referenced by:
position_list:
b_expr IN b_expr referenced by:
substr_list:
a_expr substr_from substr_for substr_for substr_from opt_expr_list referenced by:
trim_list:
a_expr FROM expr_list referenced by:
join_type:
FULL LEFT RIGHT join_outer INNER referenced by:
join_qual:
USING ( name_list ) ON a_expr referenced by:
partition:
PARTITION partition_name referenced by:
opt_name_parens:
( name ) referenced by:
reference_action:
NO ACTION RESTRICT CASCADE SET NULL DEFAULT referenced by:
opt_existing_window_name:
name referenced by:
opt_partition_clause:
PARTITION BY expr_list referenced by:
index_hints_param:
FORCE_INDEX = index_name NO_INDEX_JOIN referenced by:
extract_arg:
identifier YEAR MONTH DAY HOUR MINUTE SECOND referenced by:
overlay_placing:
PLACING a_expr referenced by:
substr_from:
FROM a_expr referenced by:
substr_for:
FOR a_expr referenced by:
join_outer:
OUTER referenced by:
partition_name:
unrestricted_name referenced by:
generated by Railroad Diagram Generator