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

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

Shalon

1 months ago

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

upvoted 0 times

...

Rosio

2 months ago

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

upvoted 0 times

...

Gregg

2 months ago

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

upvoted 0 times

...

Josefa

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

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

Lorean

1 months ago

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

upvoted 0 times

...

Jesusita

1 months ago

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

upvoted 0 times

...

Elli

2 months ago

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

upvoted 0 times

...

Sue

3 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

Tammara

1 months ago

User 3: 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

...

Frank

1 months ago

User 2: I agree with Frank, option A seems like the right choice.

upvoted 0 times

...

Lorrine

1 months ago

User 1: I think option A is the correct one.

upvoted 0 times

...

Nathalie

1 months ago

That's a valid point, but I still prefer option B.

upvoted 0 times

...

Jame

2 months ago

I would go with option A instead.

upvoted 0 times

...

Celestine

2 months ago

I agree, specifying the delimiter can be helpful.

upvoted 0 times

...

Rickie

2 months ago

I think option B is the best choice.

upvoted 0 times

...

Reed

3 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