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.

Question

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.

Accepted Answer

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

Answer

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

Answer

C. INSERT INTO t1 FROM file('users.dat');

Answer

D. INSERT INTO t1SELECT uname, pass, id FROM file('users.dat');

Answer

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

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…