PostgreSQL Exam PGCES-02 Topic 2 Question 7 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 7
Topic #: 2

[All PGCES-02 Questions]

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.

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

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

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

D\copy company TO 'company.txt'

E\copy company TO company.txt CSV

Show Suggested Answer

Suggested Answer: A

by Lizbeth at May 09, 2022, 05:31 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sue

6 days ago

I'd go with option B. Explicitly specifying the DELIMITER AS ',' makes it clear what the field separator is, which could be useful for downstream processing of the file.

upvoted 0 times

...

Reed

10 days ago

Option A seems the most straightforward way to generate the requested text file. The COPY command with the TO option is the standard way to export data to a file.

upvoted 0 times

...