Re: new line in psotgres - Mailing list pgsql-general

From abdullatheef
Subject Re: new line in psotgres
Date
Msg-id 1383995320496-5777583.post@n5.nabble.com
Whole thread Raw
In response to Re: new line in psotgres  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: new line in psotgres  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
you can include newline in postgre using literal E

create table table (text varchar(50));
insert into Table (text) values (E'This is the first part \\n And this is
the second');



--
View this message in context: http://postgresql.1045698.n5.nabble.com/new-line-in-psotgres-tp1885914p5777583.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Jayadevan M
Date:
Subject: Re: Documents/ppts/pdfs
Next
From: Alban Hertroys
Date:
Subject: Re: new line in psotgres