Re: Populating a database

Поиск
Список
Период
Сортировка
От papapep
Тема Re: Populating a database
Дата
Msg-id 3DC68C9E.4000507@gmx.net
обсуждение исходный текст
Ответ на Populating a database  (papapep <papapep@gmx.net>)
Ответы Re: Populating a database
Список pgsql-novice
First of all thanks for your ultrafast answer ;-D
Now, having a look at the copy order, it seems I've got some problems
with file permissions although I'm the root and have put all the files
and directories to 0777 (yes, I know I have to log in postgresql with
another user than root, I've done it already). Where is suposed to be
the file I'm going to insert in the databases's table? If I tell to the
copy command something like :

    \copy tablename from '\path\to\file.csv' using delimiters ','

Should it work?
Then, if yes, I don't know what I'm doing wrong, because I've set this
file to 0777 and also changed the owner to postgres.

Thanks in advance.

Josep Sànchez
  [papapep]




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: owner of type 'mmm' apperars to be invalid
Следующее
От: "cristi"
Дата:
Сообщение: Re: owner of type 'mmm' apperars to be invalid