How to enter data with '?

Question

Python

Hello everyone, I ran into such a problem that I can’t enter the Piter dog's line because there is a sign '
The dogs column has a text data type

cur.execute(f'insert into test(dogs, status) values("Piter dog's",  True);')

Error: 
Command raised an exception: UndefinedColumn: column "Piter dog's" does not exist

I need to enter exactly in this format and without using truncation by index.
Please tell me what is wrong.
Thanks a lot!

Answer 1

The question is closed.
I just made a function that changes ' to ''

Answer 2

Don't you know Backslash?

Answer 3

string = """
"""