String literals and escape characters in postgresql

by

Partially. The text is inserted, but the warning is still generated.

I found a discussion that indicated the text needed to be preceded with ‘E’, as such:

insert into EscapeTest (text) values (E'This is the first part \n And this is the second');

This suppressed the warning, but the text was still not being returned correctly. When I added the additional slash as Michael suggested, it worked.

As such:

insert into EscapeTest (text) values (E'This is the first part \\n And this is the second');

More Related Contents:

  1. Escape a string for a sed replace pattern
  2. Difference between text and varchar (character varying)
  3. Escape double quote in VB string
  4. Replace empty strings with null values
  5. Ignore escape characters (backslashes) in R strings
  6. How to compare strings in golang? [closed]
  7. Why do backslashes appear twice?
  8. Convert integers to strings to create output filenames at run time
  9. Base64 length calculation?
  10. (Swift) how to print “\” character in a string?
  11. Escape string to use in mail()
  12. How to search a string in multiple files and return the names of files in Powershell?
  13. How to capitalize the first letter of a string in dart?
  14. Jaro–Winkler distance algorithm in C#
  15. How should I remove all the leading spaces from a string? – swift
  16. How to use stringByAddingPercentEncodingWithAllowedCharacters() for a URL in Swift 2.0
  17. Number of Occurrences of a Character in NSString
  18. How to collapse a list of characters into a single string in R
  19. From String to NSDate in Swift
  20. Swift, Strings and Memory Addresses
  21. How can I Unescape and Reescape strings in .net?
  22. How to create a formatted String out of a literal in Rust?
  23. Replace String in all files in Eclipse [closed]
  24. Extract the first (or last) n characters of a string
  25. Adding backslashes without escaping [duplicate]
  26. Insert line breaks in long string — word wrap
  27. Groovy String to Date
  28. What is the difference between VBScript’s + and & operator?
  29. Remove all occurrences of \ from string
  30. Javascript – Replacing the escape character in a string literal

Leave a Comment