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

Lea

2 days 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

7 days ago

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

upvoted 0 times

...