| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | "minsheng(dot)bai" <minsheng(dot)bai(at)wellintech(dot)com>, pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: about running plpgsqlo.sql |
| Date: | 2014-01-16 15:18:56 |
| Message-ID: | 52D7F860.1010203@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2014-01-22 01:34:09 | Deferrable conditional unique constraints |
| Previous Message | minsheng.bai | 2014-01-16 08:02:08 | about running plpgsqlo.sql |