Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

EnterpriseDB PostgreSQL-Essentials Exam - Topic 2 Question 7 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam

Question #: 7
Topic #: 2

[All PostgreSQL-Essentials Questions]

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;

Show Suggested Answer

Suggested Answer: B

by Tomoko at Nov 25, 2025, 12:30 PM

Limited Time Offer

25%

Off

Get Premium PostgreSQL-Essentials Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Miriam

3 months ago

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

upvoted 0 times

...

Bettyann

3 months ago

C is close, but HEADER is misplaced.

upvoted 0 times

...

Muriel

3 months ago

A seems too simple. No header.

upvoted 0 times

...

Emiko

4 months ago

I think it's B. It includes HEADER.

upvoted 0 times

...

Stevie

4 months ago

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

upvoted 0 times

...

Anika

4 months ago

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

upvoted 0 times

...

Sylvia

5 months ago

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

upvoted 0 times

...

Anna

5 months ago

A is close, but missing the HEADER part.

upvoted 0 times

...

Reena

5 months ago

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

upvoted 0 times

...

Elliot

5 months ago

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

upvoted 0 times

...

Tran

5 months ago

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

upvoted 0 times

...

Domonique

5 months ago

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

upvoted 0 times

...

Sylvia

6 months ago

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

upvoted 0 times

...

Serina

6 months ago

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

upvoted 0 times

...

Leana

6 months ago

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

upvoted 0 times

...

Carlee

6 months ago

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

upvoted 0 times

...

Jamal

6 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.

upvoted 0 times

...

Chantell

6 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.

upvoted 0 times

...

Miesha

7 months ago

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

upvoted 0 times

...

Lynelle

7 months ago

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

upvoted 0 times

...

Cherilyn

7 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.

upvoted 0 times

...

Jules

7 months ago

B is clear and correct. I feel confident.

upvoted 0 times

...

Wilburn

7 months ago

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

upvoted 0 times

...

Anabel

8 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.

upvoted 0 times

...

Cathrine

8 months ago

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

upvoted 0 times

Adolph

2 months ago

I like B too. It’s straightforward.

upvoted 0 times

...

Cecil

2 months ago

Definitely B! The header is essential for CSV files.

upvoted 0 times

...

Shawnna

3 months ago

I was leaning towards A, but B is clearer.

upvoted 0 times

...

Johnetta

3 months ago

Yeah, B is the best choice.

upvoted 0 times

...

Jose

3 months ago

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

upvoted 0 times

...

...