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 по дате отправления: