Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 3684
3
votes
you could replace every \ with \\ in your file with a sed script or something. If the above doesn't solve your problem, please supply: PostgreSQL version Database encoding Demo data Definition of the table you COPY to The exact COPY invocation you used …
answered Mar 12 '13 by Erwin Brandstetter
4
votes
The encoding defines the very basic rules how characters are represented in binary format (like @a_horse explains in his comment). It should be mentioned that the server encoding has to match the … client encoding for successful communication. Postgres can translate if necessary, there is a dedicated setting client_encoding for this. The locale is a superset of settings, which can be split up for …
answered Aug 7 '13 by Erwin Brandstetter
3
votes
In Postgres, you would typically solve this differently. For starters, just use ILIKE for case insensitive matching. The manual: The key word ILIKE can be used instead of LIKE to make the match …
answered Dec 2 '16 by Erwin Brandstetter