Re: new line in psotgres

From: abdullatheef <latheefvkpadi(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: new line in psotgres
Date: 2013-11-09 11:08:40
Message-ID: 1383995320496-5777583.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2013-11-09 13:38:28 Re: new line in psotgres
Previous Message Jayadevan M 2013-11-09 10:20:38 Re: Documents/ppts/pdfs