PostgreSQL Exam PGCES-02 Topic 8 Question 70 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 70
Topic #: 8

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, E

by Juan at Sep 11, 2024, 02:43 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Mertie

8 days ago

I'm not sure about the answer. I think it might be D) INSERT INTO t1 SELECT uname, pass, id FROM file('users.dat').

upvoted 0 times

...

Jade

11 days ago

I agree with Mariann. Option A seems to be the most appropriate choice for inserting the contents of the text file into the table.

upvoted 0 times

...

Mariann

15 days ago

I think the correct answer is A) \\copy t1 FROM users.dat WITH DELIMITER ':' because it is used to copy data from a file into a table in psql.

upvoted 0 times

...