Re: read in to psql from file

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@klawitter.de                             http://www.klawitter.de