I have a docker Postgres image and I want to import the data from another Postgres db. The first thing I have done is to create a pg_dump on the remote server and then I have tried to import it. The problem is that output generated is simple SQL file and, if I import this file on pgAdmin I get an error:
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.
psql is not installed on my Mac because I am running it as a docker image and the file exported is using COPY to import values instead of INSERT.
The solution I have found is to export the db using –column-inserts flag:
pg_dump --column-inserts -U user db_test > db_test.2020-01-02_insert.sql
–column-inserts will dump as insert commands with column names.