On 10/5/20 7:55 AM, Mark wrote:
>
>
> Stackoverflow question link:
>
https://stackoverflow.com/questions/64210281/using-psql-executing-sql-format-file-shows-permission-denied-on-windows-platform
>
>
> I followed one PostgreSQL tutorial step by step. One session to use PSQL
> to execute sql files to create a new database in PostgreSQL.
>
> 1. copy paste the sql file within "C:\Program Files\PostgreSQL\12"
> directory.
> 2. execute the following code \i C:\\Program
> Files\\PostgreSQL\\12\\demo-big-en-20170815.sql
>
> Failed
> The message shows C:: Permission denied
> then tried \ir "C:\\Program
> Files\\PostgreSQL\\12\\demo-big-en-20170815.sql"
> Failed
> The message shows unrecognized win32 error code: 123"C:/Program
> Files/PostgreSQL/12/createdatabasesupertest.sql: Invalid argument
>
> SQL file probably was wrong. SO I tried to create a simple sql file
> (create a new database). Then I follow the above mentioned step to
> execute the file on windows PSQL. But it failed the same way just like
> the above mentioned.
>
> So basically my PSQL can not run script files. What should i do?
The issue is the user you are running psql as does not have permissions
to read the file. This is a OS permissions thing. Either run psql as a
user that can read the file or change the permissions on the file to
those that allow the psql user to read it.
>
--
Adrian Klaver
adrian.klaver@aklaver.com