Re: How to execute the sql file in PSQL

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