Re: read in to psql from file

Поиск
Список
Период
Сортировка
От Brent R. Matzelle
Тема Re: read in to psql from file
Дата
Msg-id 20010919135707.48993.qmail@web13001.mail.yahoo.com
обсуждение исходный текст
Ответ на read in to psql from file  (Doug Moore <moored3947@home.com>)
Список pgsql-general
--- 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/

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: read in to psql from file
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance question (stripped down the problem)