The following table called 'company' is defined as follows:

id | name ----+------------------ 1 | Pgsql,inc. 2 | Postgres Co.,Ltd 3 | SQL Company. Select the most appropriate psql command for generating a text file company.txt on the client side with the following content:

1,"Pgsql,inc." 2,"Postgres Co.,Ltd" 3,SQL Company.

Question

The following table called 'company' is defined as follows:

id | name ----+------------------ 1 | Pgsql,inc. 2 | Postgres Co.,Ltd 3 | SQL Company. Select the most appropriate psql command for generating a text file company.txt on the client side with the following content:

1,"Pgsql,inc." 2,"Postgres Co.,Ltd" 3,SQL Company.

Accepted Answer

E. \copycompany TO company.txt CSV

Answer

A. \copycompany TO 'company.txt' WITH ','

Answer

B. \copycompany TO 'company.txt' WITH DELIMITER AS ','

Answer

C. \copy company TO 'company.txt' DELIMITER ','

Answer

D. \copycompany TO "company.txt"

The following table called 'company' is defined as follows: id | name ----+------------------ 1 | Pgsql,inc. 2 | Postgres Co.,Ltd 3 | SQL Company. Select the most appropriate psql command for…

Question

Options

How the community answered

Community Discussion