PostgreSQL PGCES-02 Exam - Topic 1 Question 98 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 98
Topic #: 1

I would like to insert the contents of the text file users.dat into the table t1 using psql.

Contents of text file users.dat: Definition of table t1: CREATE TABLE t1 (uname TEXT, pass TEXT, id INTEGER); Select the most appropriate input from those below.

A\copy t1 FROM users.dat WITH DELIMITER ':'

B\copy t1 TO users.dat WITH DELIMITER ':'

CINSERT INTO t1 FROM file('users.dat');

DINSERT INTO t1 SELECT uname, pass, id FROM file('users.dat');

E\insert t1 FROM users.dat WITH DELIMITER ':';

Show Suggested Answer

Suggested Answer: A

by Laurena at Apr 07, 2026, 07:59 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Dorothy

18 days ago

I think B is better, though.

upvoted 0 times

...

Glendora

23 days ago

A is the right choice!

upvoted 0 times

...

Lauran

1 month ago

I recall that using INSERT INTO with a file isn't standard SQL syntax, so options C and D seem wrong to me.

upvoted 0 times

...

Becky

1 month ago

I feel like option B is about exporting data, not importing, so it can't be the right choice here.

upvoted 0 times

...

Lea

2 months ago

I'm not entirely sure, but I remember practicing with \copy commands, and it seems like the right approach for importing data.

upvoted 0 times

...

In

2 months ago

I think option A is correct because it uses \copy to load data from a file into the table.

upvoted 0 times

...