Re: about running plpgsqlo.sql - Mailing list pgsql-sql

From Adrian Klaver
Subject Re: about running plpgsqlo.sql
Date
Msg-id 52D7F860.1010203@gmail.com
Whole thread Raw
In response to about running plpgsqlo.sql  (minsheng.bai <minsheng.bai@wellintech.com>)
List pgsql-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



pgsql-sql by date:

Previous
From: minsheng.bai
Date:
Subject: about running plpgsqlo.sql
Next
From: Andreas Joseph Krogh
Date:
Subject: Deferrable conditional unique constraints