Re: Populating a database

On Mon, Nov 04, 2002 at 16:05:02 +0100,
papapep <papapep(at)gmx(dot)net> wrote:
> 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?

Are you sure you want to use \s? The normal file separator on unix
systems is /.
You may also have a problem with access to one of the directories in the
path.