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

Gregg

22 days ago

Wait, is it just me or does the table in the question look like it was made in Microsoft Excel? Someone's been spending too much time in the spreadsheet world, I tell ya!

upvoted 0 times

Rosio

1 days ago

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

upvoted 0 times

...

Gregg

2 days ago

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

upvoted 0 times

...

Josefa

26 days ago

Option E looks interesting with the CSV keyword, but I'm not sure if that's the most appropriate choice for this simple data structure. I'll stick with A or B to be safe.

upvoted 0 times

...

Cherry

27 days ago

Haha, option D is just asking to get your file named 'company.txt' instead of actually creating the file. Definitely not the right choice here.

upvoted 0 times

Elli

19 days ago

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

upvoted 0 times

...

Sue

1 months 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

Jame

9 hours ago

I would go with option A instead.

upvoted 0 times

...

Celestine

7 days ago

I agree, specifying the delimiter can be helpful.

upvoted 0 times

...

Rickie

23 days ago

I think option B is the best choice.

upvoted 0 times

...

Reed

2 months 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