Re: about running plpgsqlo.sql

On 01/16/2014 12:02 AM, minsheng.bai wrote:
> hi all
> i am using pl/secure,when i am running the scriptplpgsqlo.sqllocated in 
> thesharesubdirectory .
> 
> postgres=# \i J:\Program Files\PostgreSQL\9.3\share\plpgsqlo.sql
> 
> i get a error message:J::permission denied
> 
> i wanna know how to solve this problem.

I see empty space in a file path I see trouble, so quote the string.
Also the path separators should be / not  \.

So:
postgres=# \i  'J:/Program Files/PostgreSQL/9.3/share/plpgsqlo.sql'

> 
> thanks reply
> 
>   
> 
>   
> 
> ------------------------------------------------------------------------
> 
> minsheng.bai


-- 
Adrian Klaver
adrian.klaver@gmail.com