[prev] 51 [next]

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