Re: Change Windows path to Unix path... - Mailing list pgsql-general

--- 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