© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Search
Star
Feedback
Setup for Free
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,959
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Similar Threads
Was this page helpful?
Yes
No
Recent Announcements
Similar Threads
Problem with insert timestamp in postgres
DT
Drizzle Team / help
3y ago
Postgres insert returning expecting zero arguments
DT
Drizzle Team / help
13mo ago
Insert on postgres autoincrement expects a value
DT
Drizzle Team / help
3y ago
instanceof postgres.PostgresError not working
DT
Drizzle Team / help
11mo ago