Change Windows path to Unix path...

--- Patrick.FICHE@AQSACOM.COM wrote:

Hi,

I'm trying to execute COPY command from some pgsql
function.
The filename is given as an argument of the
function.
But I get the filename like 'F:\tmp\file.txt' and I
need to change this to
'F:/tmp/file.txt' before applying the COPY command.

I dind't succeed to replace '\' by '/' in the
filename.

Did you escape the backslash? Postgresql interprets
that as a C-style escape sequence.

Try something like:

create function win32tounix(varchar) returns varchar
as $$
select replace($1, '\\', '/');
$$ language sql;

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Thanks,

That's exactly what I was looking for.

----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tel : 01 69 29 36 18
----------------------------------------------------------------------------
---------------

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Shelby Cain
Sent: mardi 26 avril 2005 17:52
To: Patrick.FICHE@aqsacom.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Change Windows path to Unix path...

--- Patrick.FICHE@AQSACOM.COM wrote:

Hi,

I'm trying to execute COPY command from some pgsql
function.
The filename is given as an argument of the
function.
But I get the filename like 'F:\tmp\file.txt' and I
need to change this to
'F:/tmp/file.txt' before applying the COPY command.

I dind't succeed to replace '\' by '/' in the
filename.

Did you escape the backslash? Postgresql interprets
that as a C-style escape sequence.

Try something like:

create function win32tounix(varchar) returns varchar
as $$
select replace($1, '\\', '/');
$$ language sql;

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings