On 11/9/2013 5:33 PM, Gavin Flower wrote:
I redid the above, and included at test with 'E' & '\n' - just one
slash before the 'n'. The other changes are mostly cosmetic.
E'\\n' would be required if you were entering the string in a
programming language that itself used \ as an esc
On 10/11/13 09:18, Gavin Flower wrote:
On 10/11/13 02:38, Alban Hertroys wrote:
On Nov 9, 2013, at 12:08, abdullatheef wrote:
>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 i
On 10/11/13 02:38, Alban Hertroys wrote:
On Nov 9, 2013, at 12:08, abdullatheef wrote:
>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');
Or like this:
developm
On Nov 9, 2013, at 12:08, abdullatheef wrote:
> 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');
Or like this:
development=> begin;
BEGIN
development=> creat
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
I tried '\r\n' in my plperl function to check for a newline character in the
table and its working fine.
Also, would E'\n' work ?
I really did not understand if word newline is a key word for a newline
character in postgres.
Thanks,
~Jas
On 8/6/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
>
> On Mo
On Mon, 2007-08-06 at 13:28 -0400, Jasbinder Singh Bali wrote:
> Hi,
> Can anyone please tell me what is the character for a new line in
> postgres ?
> I mean how does a new line get stored in postgres ?
> Is it "\n" or "\\n" or something else ?
>
You can just put the newline directly in the SQL:
On Aug 6, 2007, at 12:28 , Jasbinder Singh Bali wrote:
Can anyone please tell me what is the character for a new line in
postgres ?
I mean how does a new line get stored in postgres ?
Is it "\n" or "\\n" or something else ?
Newlines (ASCII 10) are stored as the newline character in the
da
Hi,
Can anyone please tell me what is the character for a new line in postgres ?
I mean how does a new line get stored in postgres ?
Is it "\n" or "\\n" or something else ?
Thanks,
Jas
