| From: | Hugo <htakada(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | strings |
| Date: | 2005-11-11 22:08:45 |
| Message-ID: | f3d9ba990511111408g639e97bbq@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hrishikesh Deshmukh | 2005-11-11 22:09:52 | Reports and postgres |
| Previous Message | William Yu | 2005-11-11 21:21:58 | Re: Choosing PostgreSQL as the database for our next project |