A
A
AlexBoss2019-07-25 15:49:41
PostgreSQL
AlexBoss, 2019-07-25 15:49:41

Why can't I insert a single quote in the console client?

Connected to postgres, created a database and a table. And I can't write quotes in the console, they just don't render. What could be the problem?
Instead It turns out with copy-pasteinsert into users (Name, Age) values ('Tom', 33);
insert into users (Name, Age) values (Tom, 33);

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
ky0, 2019-07-25
@ky0

Google "character escaping".

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question