Solution for "error: could not open file "C:\Windows\Temp\ConsumerComplaints.csv" for reading: Permission denied"

Give a permission to postgres user with chown command like : sudo chown postgres:postgres /home/username/Desktop/postgresData

permission denied postgres \copy csv command line

Similar codes for "error: could not open file "C:\Windows\Temp\ConsumerComplaints.csv" for reading: Permission denied"


Latest 'SQL' questions

Added before "error: could not open file "C:\Windows\Temp\ConsumerComplaints.csv" for reading: Permission denied"