From: | "Jon Asher" <jon(at)vagabond-software(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem with sql COPY command |
Date: | 2004-08-27 22:03:34 |
Message-ID: | 20040827220336.8EAED5E3631@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm trying to do a simple import of a comma delimited text file with COPY
but it's returning an error. The file has been granted all permissions in
Linux, so it's not clear to me what the problem is. Version 7.41 is
installed... see below for details:
A comma delimited text file has been placed in a local directory with
permissions set to allow any user to read or write to it:
/root/Desktop/server_transfer/WorldPoints_v2.txt'
I'm trying to use the COPY command to import this text file into a table
from the PSQL command prompt.
First, open PSQL with parameters to open the right db: psql my_database -h
xxxx -U xxx
To import this file from the PSQL command line, call the COPY command:
copy public.world_stopwatch_v2 FROM
'/root/Desktop/server_transfer/WorldPoints_v2.txt' using delimiters ',';
COPY fails with this error message:
could not open file "/root/Desktop/server_transfer/WorldPoints_v2.txt" for
reading: Permission denied
(Database checked- it contains a table called: public.world_stopwatch_v2)
Thanks, Jon
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas F.O'Connell | 2004-08-27 22:09:24 | Re: pg_autovacuum start-script |
Previous Message | Matthew T. O'Connor | 2004-08-27 21:47:49 | Re: pg_autovacuum start-script |