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