Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
E
E
er122014-12-06 11:22:15
PostgreSQL
er12, 2014-12-06 11:22:15

How to escape quotes in Postgresql?

the table t has a column c containing two single quotes. it is necessary to make a selection with the condition that c is equal to two single quotes

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)
Report
D
Dmitry Spirin, 2014-12-07
@MipH

An apostrophe (single quote) is escaped by an apostrophe in SQL, i.e.
*total 6 apostrophes.

Report
A
Andrey Burov, 2014-12-06
@BuriK666

WHERE c = '""' OR c = '\'\''

Similar questions
Y
Yoshinon Eared2018-06-27 16:29:59
In what cases is it desirable to separate data into separate databases? 1Reply
B
bismoney2021-09-28 02:02:13
How to make postgreSQL fetch faster? 2Reply
V
vetsmen2020-07-01 14:34:07
How to write a query with joins? 1Reply
J
jenya77712018-07-03 16:20:36
How to organize a database? 2Reply
A
Alixx2021-09-30 16:21:03
Postgresql or redis for data used on sockets? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question