Search
Star
Feedback
Setup for Free
© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Insert line break in Postgres - Drizzle Team
DT
Drizzle Team
•
2y ago
•
1 reply
lelabo
Insert line break in Postgres
I am trying to insert line breaks
(
'
\n
'
) into a text field in Postgres
.
I saw that I am supposed to do the following
:
https://stackoverflow.com/questions/36028908/postgresql-newline-character
I would like to know if folks here have a solution without making a raw query to the database each time one of the field may store line breaks
?
Stack Overflow
PostgreSQL newline character
How to use newline character in PostgreSQL
?
This is an incorrect script from my experiment
:
select
'test line 1
'
'
\n
'
'test line 2
'
;
I want the sql editor display this result from my script ab
.
.
.
Drizzle Team
Join
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Similar Threads
Was this page helpful?
Yes
No
Similar Threads
Problem with insert timestamp in postgres
DT
Drizzle Team / help
3y ago
Postgres insert returning expecting zero arguments
DT
Drizzle Team / help
12mo ago
Insert on postgres autoincrement expects a value
DT
Drizzle Team / help
3y ago
instanceof postgres.PostgresError not working
DT
Drizzle Team / help
9mo ago