From: | Holger Klawitter <lists(at)klawitter(dot)de> |
---|---|
To: | Doug Moore <moored3947(at)home(dot)com>, "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: read in to psql from file |
Date: | 2001-09-19 11:39:14 |
Message-ID: | 3BA883E2.1C8EF320@klawitter.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Doug Moore wrote:
>
> Hi,
>
> As I understand it, in order to read in a file containing sql commands
> I should use the \i <file> syntax in psql.
>
> So, from the psql prompt I type:
>
> \i /root/phones
>
> I get back "/root/phones: permission denied"
>
> I am in psql as the user who owns the database.
> The file in question is readable and writeable by all.
>
Is /root executable by all?
<paranoia>
You should not make a file from root accissible by grating access to
the home of root, better push the file somewhere else and "chown" the
file.
</paranoia>
With kind regards / Mit freundlichem Gruß
Holger Klawitter
--
Holger Klawitter
holger(at)klawitter(dot)de http://www.klawitter.de
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2001-09-19 11:52:16 | Re: www.postgresql.org |
Previous Message | Vince Vielhaber | 2001-09-19 11:19:58 | Re: www.postgresql.org |