Postgres ERROR: could not open file for reading: Permission denied

by

Assuming the psql command-line tool, you may use \copy instead of copy.

\copy opens the file and feeds the contents to the server, whereas copy tells the server the open the file itself and read it, which may be problematic permission-wise, or even impossible if client and server run on different machines with no file sharing in-between.

Under the hood, \copy is implemented as COPY FROM stdin and accepts the same options than the server-side COPY.

More Related Contents:

  1. Why the “Group BY” by month didn’t work? [closed]
  2. What to do with null values when modeling and normalizing?
  3. Postgres: INSERT if does not exist already
  4. Truncating all tables in a Postgres database
  5. How can I drop all the tables in a PostgreSQL database?
  6. postgres default timezone
  7. quick random row selection in Postgres
  8. Running PostgreSQL in memory only
  9. How to close idle connections in PostgreSQL automatically?
  10. postgresql – replace all instances of a string within text field
  11. Is it possible to have autoincrement number without it being an ID?
  12. How do I login and authenticate to Postgresql after a fresh install?
  13. pgadmin4 : postgresql application server could not be contacted.
  14. PostgreSQL error ‘Could not connect to server: No such file or directory’
  15. function returns multiple columns as a single column instead of multiple columns
  16. Postgres: check if array field contains value?
  17. Dynamic pivot query using PostgreSQL 9.3
  18. eliminate duplicate array values in postgres
  19. Strange behaviour in Postgresql
  20. Postgres: Distinct but only for one column
  21. In PostgreSQL, how to insert data with COPY command?
  22. Cursor based records in PostgreSQL
  23. How to add column if not exists on PostgreSQL?
  24. Maximum characters in labels (table names, columns etc)
  25. Configuration parameter work_mem in PostgreSQL on Linux
  26. How to work with PGpoint for Geolocation using PostgreSQL?
  27. Postgres default sort by id – worldship
  28. Best way to install hstore on multiple schemas in a Postgres database?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment