PostgreSQL PGCES-02 Exam - Topic 6 Question 15 Discussion

Question

PostgreSQL PGCES-02 Exam - Topic 6 Question 15 Discussion

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.

A) \copy company TO 'company.txt' WITH ',';

B) \copy company TO 'company.txt' WITH DELIMITER AS ',';

D) \copy company TO 'company.txt'

E) \copy company TO company.txt CSV

Accepted Answer

C) \copy company TO 'company.txt' DELIMITER ','

PostgreSQL PGCES-02 Exam - Topic 6 Question 15 Discussion

PostgreSQL PGCES-02 Exam - Topic 6 Question 15 Discussion

Contribute your Thoughts:

Amalia

Dorathy

Gerald

Carry

Alecia

Antonio

Viola

Justine

Joana

Ahmed

Maurine