I am trying to run the following command using psql but the --file argument is ignored event tough I manage to connect to the database.
psql "postgresql://postgres:admin12345@localhost:5432/Phoenix" -f "tables/book.sql"
The output on the terminal is as the screenshot shows.
What am I missing here? Thanks in advance.
After googling and wasting hours on testing different SO answers, this worked for me:
psql -f "tables/book.sql" "postgresql://postgres:admin12345@localhost:5432/Phoenix"
It looks like the psql command requires that the command-line arguments appear before the connection string. That's a bit weird but it worked for me.
Also the quotes are optional. This also works:
psql -f tables/book.sql postgresql://postgres:admin12345@localhost:5432/Phoenix
I tried changing code page as indicated on the section "Notes for Windows Users" in the psql doc psql docmentation. The result is the warning does not show anymore but the command line args are still ignored if the connection string precedes them like as shown in the following logs:
C:\Users\Zack
λ cmd.exe /c chcp 1252
Active code page: 1252
C:\Users\Zack
λ psql postgresql://postgres:admin12345@localhost:5432/Phoenix -f "tables/book.sql"
psql: warning: extra command-line argument "tables/book.sql" ignored
psql (13.2)
Type "help" for help.
Phoenix=#
Theo only fix that works for me now is making the other args preced the connection string.
If someone knows more about why command-line args should precede the connection string, please provide more details.
psql "postgresql://postgres:@localhost:5432/test" -f "test_sql.sql" and psql -d test -U postgres -f "test_sql.sql" work just fine for me on Linux.
-fdoesn't look like a proper f