How do I use COPY FROM on a backup file with multiple tables?

0 votes

0 answers

682 views

                          I used this command to backup my "supplies" table:

    COPY supplies (id, price, ...) FROM 'C:\Users\MyCompany\Desktop\database03-01-2022.sql';

But now, I would like to write three more tables' data into that file, and call the same COPY FROM command.

1. Is that possible?
2. How should the file be formatted?
3. Will the COPY FROM command need to change?

Thank you for your time.

Asked by water_enjoyer (1 rep)

Mar 8, 2022, 05:40 PM

How do I use COPY FROM on a backup file with multiple tables?

Related Questions