Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> writes:
> Basically if you have a function in your view SQL like this:
> replace(address1, '\r', '')
> pg_get_viewdef is returning the view definition with the \r replaced by
> it's ASCII code which causes this:
> replace(address1, '
> ','')
This is not incorrect, if the original was interpreted under
escape-string syntax. Perhaps you meant to type \\r ?
regards, tom lane