Week 01 Lectures (53)

exec_simple_query(const char *query_string)

defined in src/backend/tcop/postgres.c
entry point for evaluating SQL queries
assumes query_string is one or more SQL statements
performs much setting up/initialisation
parses the SQL string (into one or more parse trees)
for each parsed query ...
- perform any rule-based rewriting
- produces an evaluation plan (optimisation)
- execute the plan, sending tuples to client