64.1k views
1 vote
Which of the following statements would dump only the table customer from the mydatabase database to ?

-pg dump -a customer mydatabase >
-pg dump -t customer mydatabase >
-pg dump mydatabase customer >
-pg dump -t customer >

1 Answer

6 votes

Final answer:

To dump only the 'customer' table from the 'mydatabase' database, the correct command is 'pg_dump -t customer mydatabase >'.

Step-by-step explanation:

The statement to dump only the table customer from the mydatabase database is: pg_dump -t customer mydatabase >. The correct syntax starts with the pg_dump command followed by the -t option to specify the table name, which in this case is 'customer', then the name of the database 'mydatabase', and lastly the redirection operator '>' to specify the destination of the dump.

The correct statement to dump only the table customer from the mydatabase database is -pg dump -t customer mydatabase >. This command will specify the table 'customer' and the database 'mydatabase' to be dumped.

User Arun Aravind
by
8.6k points