Thread: about running plpgsqlo.sql
hi all
i am using pl/secure,when i am running the script plpgsqlo.sql located in the share subdirectory .
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.
thanks reply
minsheng.bai
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