read in to psql from file

Поиск
Список
Период
Сортировка
От Doug Moore
Тема read in to psql from file
Дата
Msg-id 3BA62042.8EFC0463@home.com
обсуждение исходный текст
Ответы Re: read in to psql from file  (Andrew Gould <andrewgould@yahoo.com>)
Re: read in to psql from file  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: read in to psql from file  ("Brent R. Matzelle" <bmatzelle@yahoo.com>)
Re: read in to psql from file  ("Roderick A. Anderson" <raanders@tincan.org>)
Список pgsql-general
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


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

Предыдущее
От: "Mark Muffett"
Дата:
Сообщение: Booleans
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Performance question (stripped down the problem)