PostgreSQL Exam PGCES-02 Topic 4 Question 72 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 72
Topic #: 4

[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 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 ',';

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: C

by Shawnta at Sep 12, 2024, 09:07 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ernest

2 months ago

Option F: \copy company TO 'company.txt' WITH DELIMITER AS ',' AND QUOTE AS '\' AND ESCAPE AS '\\'

upvoted 0 times

Haydee

1 months ago

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

upvoted 0 times

...

Alaine

1 months ago

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

upvoted 0 times

...

Vincenza

2 months ago

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

upvoted 0 times

...

Cristal

2 months ago

E is interesting, but I'm not sure if it will handle the escaped commas in the name column correctly. I'd stick with B or C to be safe.

upvoted 0 times

...

Bettyann

2 months ago

But A) specifies the delimiter as ',' which matches the content of the table, so it should be the correct answer.

upvoted 0 times

...

Ammie

2 months ago

I disagree, I believe the correct answer is E) \\copy company TO company.txt CSV

upvoted 0 times

...

Nadine

2 months ago

D seems a bit too simple. I think we need more control over the output format, so I'd choose B or C.

upvoted 0 times

Pamella

2 months ago

Yeah, C seems like a good choice for generating the text file with the desired content.

upvoted 0 times

...

Lovetta

2 months ago

C could also work since it specifies the delimiter directly in the command.

upvoted 0 times

...

Devora

2 months ago

I agree, B gives us more control over the output format compared to D.

upvoted 0 times

...

Sherita

2 months ago

I think B is the best option for generating the text file with the specified content.

upvoted 0 times

...

Laurel

3 months ago

I'd go with C. The DELIMITER ',' syntax is nice and straightforward for this use case.

upvoted 0 times

...

Corinne

3 months ago

Option B looks good to me. Using the DELIMITER AS parameter is the way to go when exporting a table to a text file with a custom delimiter.

upvoted 0 times

Sage

1 months ago

Option B looks good to me. Using the DELIMITER AS parameter is the way to go when exporting a table to a text file with a custom delimiter.

upvoted 0 times

...

Loren

2 months ago

I'm not sure, but I think option C might work.

upvoted 0 times

...

Thad

2 months ago

No, I believe option B is the best choice.

upvoted 0 times

...

Fernanda

2 months ago

I think option A is the correct one.

upvoted 0 times

...

Bettyann

3 months ago

I think the answer is A) \\copy company TO 'company.txt' WITH ',';

upvoted 0 times

...