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

Margret

1 days ago

I agree with Whitney. Using the correct delimiter is crucial for generating the text file correctly.

upvoted 0 times

...

Whitney

3 days ago

I think the answer is A) \\copy company TO 'company.txt' WITH ',' because it specifies the delimiter as a comma.

upvoted 0 times

...