agora inbox for pgsql-sql@postgresql.orghelp / color / mirror / Atom feed
about running plpgsqlo.sql 2+ messages / 2 participants [nested] [flat]
* about running plpgsqlo.sql @ 2014-01-16 08:02 minsheng.bai <minsheng.bai@wellintech.com> 0 siblings, 1 reply; 2+ messages in thread From: minsheng.bai @ 2014-01-16 08:02 UTC (permalink / raw) To: pgsql-sql; pgsql-sql; pgsql-sql; pgsql-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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: about running plpgsqlo.sql @ 2014-01-16 15:18 Adrian Klaver <adrian.klaver@gmail.com> parent: minsheng.bai <minsheng.bai@wellintech.com> 0 siblings, 0 replies; 2+ messages in thread From: Adrian Klaver @ 2014-01-16 15:18 UTC (permalink / raw) To: minsheng.bai <minsheng.bai@wellintech.com>; 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-01-16 15:18 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-01-16 08:02 about running plpgsqlo.sql minsheng.bai <minsheng.bai@wellintech.com> 2014-01-16 15:18 ` Adrian Klaver <adrian.klaver@gmail.com>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox