PostgreSql, unterminated quoted string [duplicate]

Question

i am using Postgresql Db. i got this error for using ' on a text,

unterminated quoted string at or near "'\'')"

it is my function call:

SELECT "public"."sendMessage"(12152015, 12584, 1258487, 13960614093221020, '\'')

how can i insert these characters into db without any problem??

This is also documented in the manual: postgresql.org/docs/current/static/… — user330315
– user330315, Commented Sep 5, 2017 at 9:51

Andomar · Accepted Answer · 2017-09-05 09:36:58Z

3

The right way to quote a single quote is to repeat it, not to escape it:

SELECT "public"."sendMessage"(12152015, 12584, 1258487, 13960614093221020, '''')
                                                                            ^^

answered Sep 5, 2017 at 9:36

Andomar

239k55 gold badges387 silver badges412 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Saeed Over a year ago

and what about double quotation and other special characters user can enter??

Mark Rotteveel Over a year ago

@Saeed.At Double quotes are not special characters in a string literal.

Andomar Over a year ago

Single quote is the only character that you have to escape. It's better to use parameterized queries and have the database library do this for you.

user330315 Over a year ago

@Saeed.At: see the manual for details: postgresql.org/docs/current/static/…

Saeed Over a year ago

Also, a single quote can be included in an escape string by writing \', in addition to the normal way of ''.@a_horse_with_no_name , but it does not true, is it?

Collectives™ on Stack Overflow

PostgreSql, unterminated quoted string [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related