PostgreSQL PGCES-02 Exam - Topic 6 Question 15 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 15
Topic #: 6

[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 Latrice at May 05, 2022, 07:54 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Amalia

4 months ago

Surprised there's no option for headers in the output!

upvoted 0 times

...

Dorathy

4 months ago

Wait, is DELIMITER even a valid keyword here?

upvoted 0 times

...

Gerald

4 months ago

I’m leaning towards E, CSV seems more appropriate.

upvoted 0 times

...

Carry

4 months ago

Definitely not A, that syntax is off.

upvoted 0 times

...

Alecia

4 months ago

I think option C is the right one.

upvoted 0 times

...

Antonio

5 months ago

I feel like I might have seen an example where the CSV format was used, so maybe option E could be the answer?

upvoted 0 times

...

Viola

5 months ago

I remember practicing a similar question, and I think option C looks familiar, but I can't recall if it was exactly right.

upvoted 0 times

...

Justine

5 months ago

I think the command should include the delimiter, but I'm not sure if "WITH" is necessary.

upvoted 0 times

...

Joana

5 months ago

I'm a bit confused about the syntax; I thought "WITH DELIMITER AS" was correct, but now I'm not so sure.

upvoted 0 times

...

Ahmed

5 months ago

Hmm, I'm not totally sure about this one. I know CyberArk has a lot of different components, and I'm not super familiar with how they all work together. I'll have to think this through carefully.

upvoted 0 times

...

Maurine

5 months ago

I think B is the right answer here. Setting the max file size directly seems like the most straightforward way to ensure the persistent store doesn't exceed 1GB.

upvoted 0 times

...