permissions failure to copy csv data

Поиск
Список
Период
Сортировка
От e-letter
Тема permissions failure to copy csv data
Дата
Msg-id AANLkTinEskECORCCoXt9vJM5QApdAPriMnYvxREbrSdg@mail.gmail.com
обсуждение исходный текст
Ответы Re: permissions failure to copy csv data
Список pgsql-novice
Readers,

The following command was entered from normal user account where csv files are:

COPY newdatabasenametable FROM '/path/to/file.csv' WITH CSV;
ERROR:  could not open file "/path/to/file.csv" for reading: Permission denied

Superuser X created by linux root account but unable to read csv files
even though permissions are read-execute for others (tried to change
to read-write-execute, no success):

su root
su postgres
createuser X
createdb -U X newdatabasename

When changing to postgres account:

pwd: /path/to/

su root
su postgres
psql newdatabasename
could not change directory to "/path/to
Welcome to psql 8.2.13, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

How do I configure the permissions correctly?

Yours,

postgresql@conference.jabber.org
postgresql8213
mandriva2008

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

Предыдущее
От: Andrej
Дата:
Сообщение: Re: Like and Not LIke
Следующее
От: Helgi Örn Helgason
Дата:
Сообщение: Re: MySQL --> PostgreSQL with PHP