Thanks, That's exactly what I was looking for.
---------------------------------------------------------------------------- --------------- Patrick Fiche email : [EMAIL PROTECTED] tel : 01 69 29 36 18 ---------------------------------------------------------------------------- --------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Shelby Cain Sent: mardi 26 avril 2005 17:52 To: [EMAIL PROTECTED]; [email protected] Subject: Re: [GENERAL] Change Windows path to Unix path... --- [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
