PostgreSQL Exam PGCES-02 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

Currently there are no comments in this discussion, be the first to comment!