problems with copy - Mailing list pgsql-general

From Steff
Subject problems with copy
Date
Msg-id 96vqhh$1m1$1@buty.wanadoo.nl
Whole thread Raw
List pgsql-general
Hello

I'm starting using PostgreSQL and want to import datas from my old database.
I've made ASCII delimited files and want to use the copy instruction.

Having the server started, I do the following :

> psql mydb
>copy table from 'myfile' using delimiters ';' ;

I'vegot an error saying that the backend server can't read myfile. I've
check rights on this file and every user can read this file.
I've created the table and checked that it exists.
    Can someone help Me ??

Thanks in advance

Stephane



pgsql-general by date:

Previous
From: mg
Date:
Subject: Error: 'cache lookup failed' w/trigger
Next
From: Lonnie Cumberland
Date:
Subject: Re: Re: postmaster question