nerdexam
PostgreSQL_CE

PGCES-02 · Question #59

Select one incorrect statement about the SQL COPY command.

The correct answer is B. You can output the row data of a table to a specified client side file. See the full explanation below for the reasoning.

Question

Select one incorrect statement about the SQL COPY command.

Options

  • AIt copies data between a file and a table.
  • BYou can output the row data of a table to a specified client side file.
  • CCopies row data froma file into a table.
  • DOnly thesuperuser can specify the output file name.
  • EThe delimiter thatseparates column data can be changed from the default TAB character.

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    80% (20)
  • C
    12% (3)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PGCES-02 Practice