From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | Doug Moore <moored3947(at)home(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: read in to psql from file |
Date: | 2001-09-19 13:34:11 |
Message-ID: | 20010919133411.19531.qmail@web13408.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)home(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-09-19 13:55:04 | Re: Performance question (stripped down the problem) |
Previous Message | Tille, Andreas | 2001-09-19 13:32:11 | Re: Performance question (stripped down the problem) |