strings - Mailing list pgsql-general

From Hugo
Subject strings
Date
Msg-id f3d9ba990511111408g639e97bbq@mail.gmail.com
Whole thread Raw
Responses Re: strings  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,
calling a function with select esquema.fn_importa_csv('c:\file.csv')
I get this errror:

ERROR:  could not open file "c:file.csv" for reading: No such file or directory
CONTEXT:  SQL statement "copy comisiones.avon( zona,ano,campana,fechapro,contrato,situacion,documento,tipo,subtipo,exentas,gravadas,iva,importe ) from  'c:\file.csv'  with CSV"
PL/pgSQL function "fn_importa_csv" line 11 at execute statement

but if I call it with select esquema.fn_importa_csv('c:\\\\file.csv') everything works fine, what can I do to call the function with the 'c:\file.csv' parameter and make it work ??

thanks for any help

Hugo

pgsql-general by date:

Previous
From: "Prasad Duggineni"
Date:
Subject: postgres 8.1 compile error in the pg_attribute.h file
Next
From: Hrishikesh Deshmukh
Date:
Subject: Reports and postgres