Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: export csv file on XP


  • From: Raymond O'Donnell <rod(at)iol(dot)ie>
  • To: Wang Kuo-Ying <stu93303148(at)gmail(dot)com>
  • Cc: pgsql-general(at)postgresql(dot)org
  • Subject: Re: export csv file on XP
  • Date: Fri, 31 Jul 2009 17:12:02 +0100
  • Message-id: <4A7317D2.90303@iol.ie> <text/plain>

On 31/07/2009 16:57, Wang Kuo-Ying wrote:

> Command:
> copy test to 'c:/test.csv'
> delimiters ',' ;
> 
> but the error ERROR:  could not open file "c:/test.csv" for writing:
> Permission denied

Looks like a permissions problem - check that the user as which the
server is running has read permissions on that file.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group