PostgreSQL_CE
PGCES-02 · Question #29
PGCES-02 Question #29: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.
Question
The following table called 'company' is defined as follows: id | name ----+------------------ 1 | Pgsql,inc. 2 | Postgres Co.,Ltd 3 | SQL Company. Select the most appropriate psql command for generating a text file company.txt on the client side with the following content: 1,"Pgsql,inc." 2,"Postgres Co.,Ltd" 3,SQL Company.
Options
- A\copycompany TO 'company.txt' WITH ','
- B\copycompany TO 'company.txt' WITH DELIMITER AS ','
- C\copy company TO 'company.txt' DELIMITER ','
- D\copycompany TO "company.txt"
- E\copycompany TO company.txt CSV
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.