Re: Populating a database - Mailing list pgsql-novice

From papapep
Subject Re: Populating a database
Date
Msg-id 3DC68C9E.4000507@gmx.net
Whole thread Raw
In response to Populating a database  (papapep <papapep@gmx.net>)
Responses Re: Populating a database  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: owner of type 'mmm' apperars to be invalid
Next
From: "cristi"
Date:
Subject: Re: owner of type 'mmm' apperars to be invalid