Run a PostgreSQL .sql file using command line arguments

by

Of course, you will get a fatal error for authenticating, because you do not include a user name…

Try this one, it is OK for me 🙂

psql -U username -d myDataBase -a -f myInsertFile

If the database is remote, use the same command with host

psql -h host -U username -d myDataBase -a -f myInsertFile

More Related Contents:

  1. How do I specify a password to ‘psql’ non-interactively?
  2. PostgreSQL “DESCRIBE TABLE”
  3. How to exit from PostgreSQL command line utility: psql
  4. In psql, why do some commands have no effect?
  5. Run batch file with psql command without password
  6. Restore a postgres backup file using the command line?
  7. How to switch databases in psql?
  8. Postgresql: Scripting psql execution with password
  9. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  10. PostgreSQL: encoding problems on Windows when using psql command line utility
  11. psql: FATAL: database “” does not exist
  12. PostgreSQL: Why psql can’t connect to server?
  13. Use variable set by psql meta-command inside of DO block
  14. Alternate output format for psql showing one column per line with column name
  15. Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
  16. PostgreSQL disable more output
  17. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  18. How to make “case-insensitive” query in Postgresql?
  19. postgresql duplicate key violates unique constraint
  20. gem install pg –with-pg-config works, bundle fails
  21. Find difference between timestamps in seconds in PostgreSQL
  22. Unable to connect PostgreSQL to remote database using pgAdmin
  23. How can I change a PostgreSQL user password?
  24. I forgot the password I entered during PostgreSQL installation
  25. Postgres JSON data type Rails query
  26. Postgresql enforce unique two-way combination of columns
  27. how to store PostgreSQL jsonb using SpringBoot + JPA?
  28. Orbeon Forms Postgres DB connection
  29. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment