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

Doug,

1. Put the file in single quotes:
\i '/root/phones'

2. Check the permissions on the directory /root/.

I would suggest that the permissions for the directory
/root/ be left alone and for you to move executable
scripts to a different directory.

Best of luck,

Andrew Gould

--- Doug Moore <moored3947@home.com> 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.

What do I do next?

V/R,
Doug Moore

---------------------------(end of
broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/

--- Doug Moore <moored3947@home.com> 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.

You have given rights for everyone on your machine to read/write
to the /root directory? Enter the /root directory and run this
(if 'phones' is the sql file):
% psql -f phones

Brent

__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/

Doug Moore <moored3947@home.com> writes:

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.

And what about the /root directory?

regards, tom lane

On Mon, 17 Sep 2001, Doug Moore wrote:

Hi,

\i /root/phones

I get back "/root/phones: permission denied"

Most probably you don't have access to /root. Regardless of the
permissions on a file in the directory if you can't get into the
directory you can get to the file.
I suggest you move the file to a more open location verses opening
/root up.

I am in psql as the user who owns the database.
The file in question is readable and writeable by all.

Cheers,
Rod
--
A small clue and no money
will get you further than
lots of money and no clue.