Bash / Docker exec: file redirection from inside a container

Try and use a shell to execute that command

sh -c 'psql --host=127.0.0.1 --username=foo foo < /usr/src/app/migrations/*.sql'

The full command would be:

docker exec -it app_pgsql sh -c 'psql --host=127.0.0.1 --username=foo foo < /usr/src/app/migrations/*.sql'

try with sh -c "your long command"

Also working when piping backup to the mysql command:

cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

Related