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

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