Discuss EnterpriseDB PostgreSQL-Essentials Exam Topic 2 Question 7

You want to export the emp table to a CSV file with column headers using the COPY command. Which command should you use?

ACOPY emp TO '/path/emp.csv' WITH CSV;

BCOPY emp TO '/path/emp.csv' WITH CSV HEADER;

CCOPY emp TO '/path/emp.csv' DELIMITER ',' HEADER;

DEXPORT emp TO '/path/emp.csv' CSV HEADER;

Suggested Answer: B

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

30 comments · newest first

Miriam 6 months ago

I agree with B. It’s the best choice.

Bettyann 6 months ago

C is close, but HEADER is misplaced.

Muriel 6 months ago

A seems too simple. No header.

Emiko 7 months ago

I think it's B. It includes HEADER.

Stevie 7 months ago

C is wrong, it should be WITH CSV, not just CSV.

Anika 7 months ago

Wait, can you really use COPY like that? Seems too easy!

Sylvia 8 months ago

I thought D was valid, but I guess EXPORT isn't a command?

Anna 8 months ago

A is close, but missing the HEADER part.

Reena 8 months ago

B) all the way, baby! Gotta love those column headers. Makes the data so much more readable.

Elliot 8 months ago

Hmm, I'm going with B). Seems like the most straightforward way to get that CSV file exported.

Tran 8 months ago

C) COPY emp TO '/path/emp.csv' DELIMITER ',' HEADER; looks good to me. Keeps things nice and tidy.

Domonique 8 months ago

B) is the way to go. Gotta have those column headers, am I right?

Sylvia 9 months ago

B) COPY emp TO '/path/emp.csv' WITH CSV HEADER; is the correct answer.

Serina 9 months ago

I feel like "EXPORT" is not the correct command here, so D is definitely out.

Leana 9 months ago

I'm not entirely sure, but I think "COPY" is the right command, so it could be A or B.

Carlee 9 months ago

I remember practicing a similar question, and I feel like "WITH CSV HEADER" is the right syntax.

Jamal 9 months ago

I got this! The answer is definitely B. The COPY command with the CSV HEADER option is the way to go for exporting a table to a CSV file with column headers.

Chantell 9 months ago

Okay, let me think this through. We want to export the emp table to a CSV file with column headers, so I'm leaning towards either B or C. I'll review the details of the COPY command to make sure I'm choosing the correct one.

Miesha 10 months ago

I think the command should include "HEADER" to get the column names, so maybe it's B?

Lynelle 10 months ago

Definitely B! You need the HEADER option for column names.

Cherilyn 10 months ago

Ah, I remember this from the last class. The key is using the HEADER option to include the column names. I'm pretty confident B is the right answer.

Jules 10 months ago

B is clear and correct. I feel confident.

Wilburn 10 months ago

D uses EXPORT, not COPY. That's wrong.

Anabel 11 months ago

Hmm, I'm a bit unsure about this one. I know the COPY command is used for exporting data, but I'm not 100% sure about the specific syntax. I'll have to double-check the documentation.

Cathrine 11 months ago

I think the answer is B. The COPY command with the CSV HEADER option should do the trick.

Adolph 5 months ago

↳ replying to Cathrine

I like B too. It’s straightforward.

Cecil 5 months ago

↳ replying to Cathrine

Definitely B! The header is essential for CSV files.

Shawnna 6 months ago

↳ replying to Cathrine

I was leaning towards A, but B is clearer.

Johnetta 6 months ago

↳ replying to Cathrine

Yeah, B is the best choice.

Jose 6 months ago

↳ replying to Cathrine

I agree, B seems right. It includes the header.

EnterpriseDB PostgreSQL-Essentials Exam - Topic 2 Question 7 Discussion