Discuss PostgreSQL PGCES-02 Exam Topic 6 Question 93

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

Suggested Answer: E

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

31 comments · newest first

Lezlie 6 months ago

E is interesting, but I think it’s missing quotes for the filename.

Werner 6 months ago

D is too vague. It doesn’t mention the delimiter.

Kaycee 6 months ago

C seems good too. But I’m unsure about the syntax.

Malcom 6 months ago

I prefer B. It specifies the delimiter clearly.

Ramonita 6 months ago

It uses the right syntax for copying.

Fletcher 6 months ago

Why A?

Ramonita 7 months ago

I think option A is correct.

Sommer 7 months ago

E) seems off, I don't remember CSV being used like that.

Sabrina 7 months ago

Wait, why is D) even an option? It doesn't specify the format!

Florinda 8 months ago

C) looks good, but I’m not sure about the DELIMITER keyword placement.

Moon 8 months ago

I think B) is incorrect, it doesn't use the right syntax.

Pete 8 months ago

A) is the right choice!

Tu 8 months ago

Wait, is this a trick question? I'm going with E just to be safe.

Ronna 8 months ago

Haha, I bet the exam writer is a big fan of PostgreSQL. Option B is the way to go!

Beckie 8 months ago

D is the easiest option, no need to worry about delimiters.

Caprice 9 months ago

I feel like option E is close, but I don’t recall if CSV is the right keyword to use for this context.

Nu 9 months ago

I’m a bit confused about whether I should use quotes around the filename in option D. It seems off to me.

Helga 9 months ago

I remember practicing a similar question, and I feel like the correct command needs to specify the delimiter properly.

Terina 9 months ago

I think the answer is C) \copy company TO 'company.txt' DELIMITER ','. This seems to be the most straightforward way to export the table data to a text file with the comma as the delimiter.

Jennifer 9 months ago

I'm not too confident about this one. I'll need to think it through carefully and make sure I understand the differences between the options before selecting an answer.

Kiley 9 months ago

Okay, I've got this. The answer is B) \copy company TO 'company.txt' WITH DELIMITER AS ','. This will export the table data to a text file with the comma as the delimiter, which matches the required format.

Ria 10 months ago

I think option A looks familiar, but I'm not sure if the syntax is exactly right for the delimiter.

Lorriane 10 months ago

Option B looks good to me.

Nan 10 months ago

I think C is the correct answer. The DELIMITER keyword is used to specify the delimiter.

Yolando 11 months ago

Hmm, I'm a bit confused. There are a few options here, and I'm not sure which one is the most appropriate. I'll need to review the psql documentation to make sure I understand the differences between these commands.

Mignon 11 months ago

I think I know how to approach this. The key is to look for the psql command that can export the table data to a text file with the specified format.

France 5 months ago

↳ replying to Mignon

I’m leaning towards A as well.

Fletcher 5 months ago

↳ replying to Mignon

I think E is the best for CSV format.

Markus 5 months ago

↳ replying to Mignon

Option C looks good too.

Talia 10 months ago

↳ replying to Mignon

I believe option A is the right choice.

Helene 10 months ago

↳ replying to Mignon

What about option B? It seems valid.

PostgreSQL PGCES-02 Exam - Topic 6 Question 93 Discussion