By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

Input file:permission denied

P: 2
hi,

i started the postgresql client the first time and wanted to execute commands from file and got the following error code:
Expand|Select|Wrap|Line Numbers
  1. \i x:\file.sql
  2. x:: Permission denied
i have admin rights, so why?

WinVista Business
PostgreSQL Version 8.2.6

thanks for help
Jan 18 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
hi,

i started the postgresql client the first time and wanted to execute commands from file and got the following error code:
Expand|Select|Wrap|Line Numbers
  1. \i x:\file.sql
  2. x:: Permission denied
i have admin rights, so why?

WinVista Business
PostgreSQL Version 8.2.6

thanks for help
Check once again if you have correct right and i think it should be something like that
\i E'x:\\file.sql'
see in the manual at postgresql.org
Jan 18 '08 #2

P: 2
Check once again if you have correct right and i think it should be something like that
\i E'x:\\file.sql'
see in the manual at postgresql.org
ok thanks it works now. it was just
Expand|Select|Wrap|Line Numbers
  1. \i 'x:\\file.sql'
without the"E"
Jan 18 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.