In Git Bash, How Do I Fix a "Stdin Is Not a Tty" Error?
I'm Using Git Bash on Windows 10. I Would Like to Import a Sql File to Be Run in My Postgres 12 Local Database. I Tried the Below $ Pgpassword=$Db_Password...
I'm using Git Bash on Windows 10. I would like to import a SQL file to be run in my PostGres 12 local database. I tried the below
$ PGPASSWORD=$DB_PASSWORD psql -U${DB_USER} $DB_NAME < scripts/my-script.sql
stdin is not a tty
When I look in my database, the script hasn't been run, which leads me to believe the error message is telling me why, except I'm not sure what it means or how to fix it.
1 Answer
Don't use redirection on Windows (in general, not just in "git-bash").
Pass the script file using the -f parameter:
PGPASSWORD=$DB_PASSWORD psql -U${DB_USER} -f scripts/my-script.sql $DB_NAME
Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.
