PostgreSQL server (cont)
As well as handling SQL queries, PostgresqlMain also
- handles "utility" commands e.g.
CREATE TABLE
- most utility commands modify catalog (e.g.
CREATE X)
- other commands affect server (e.g.
vacuum )
- handles
COPY command
- special
COPY mode; context is one table
- reads line-by-line, treats each line as tuple
- inserts tuples into table; at end, checks constraints
|