I installed postgresql 8.2 and when I try to copy csv data into a
table the following error is popping up:
==================================
~ victor$ psql meteodm
Welcome to psql 8.2.11 (server 8.3.1), the PostgreSQL interactive
terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
meteodm=# COPY comuni from '/Users/victor/Documents/DATABASE/
comunitaliani.csv'meteodm-# with delimiter as ',';
ERROR: could not open file "/Users/victor/Documents/DATABASE/
comunitaliani.csv" for reading: Permission denied
meteodm=#
=================================
The permissions are as follows:
~ victor$ ls -al Documents/DATABASE/
total 8904
drwxr-xr-x 10 victor postgres 340 13 Ott 14:41 .
lrwxr-xr-x 1 victor postgres 31 13 Ott
14:36 .#comunitaliani.csv -> [email protected]
drwx------+ 118 victor staff 4012 13 Ott 12:28 ..
-rw-r-xr-x@ 1 victor postgres 6148 6 Lug 17:37 .DS_Store
-rwxrwxrwx 1 victor postgres 2592768 16 Apr 11:03 Gestione
documentazioni.fp7
-rw-r-xr-x@ 1 victor postgres 53248 21 Mar 2009 Senza nome.fp7
-rw-r-xr-x@ 1 victor postgres 786919 13 Ott 12:42
comuni_italiani.csv
-rw-r-xr-x@ 1 victor postgres 786761 13 Ott 14:41 comunitaliani.csv
-rw-r-xr-x@ 1 victor postgres 65536 31 Mar 2009 meteodm
Convertito.fp7
-rw-r-xr-x@ 1 victor postgres 253952 21 Mar 2009 senzanome.fp7
MacBookVictor-2:~ victor$
What's the matter with it and why I can't read the fil
Thanks
Vittorio
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Fink-beginners mailing list
[email protected]
http://news.gmane.org/gmane.os.apple.fink.beginners
