PostgreSQL_CE
PGCES-02 · Question #57
PGCES-02 Question #57: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #57. 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 with the following content on the client side. 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\copycompany 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.