Re: new line in psotgres
От
Jeff Davis
Тема
Re: new line in psotgres
Дата
Msg-id
1186424381.27681.20.camel@dogma.ljc.laika.com
Ответ на
new line in psotgres (Jasbinder Singh Bali)
Список
Дерево обсуждения
new line in psotgres "Jasbinder Singh Bali" <jsbali@gmail.com>
Re: new line in psotgres Jeff Davis <pgsql@j-davis.com>
Re: new line in psotgres "Jasbinder Singh Bali" <jsbali@gmail.com>
Re: new line in psotgres Michael Glaesemann <grzm@seespotcode.net>
Re: new line in psotgres abdullatheef <latheefvkpadi@gmail.com>
Re: new line in psotgres Alban Hertroys <haramrae@gmail.com>
Re: new line in psotgres Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: new line in psotgres Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: new line in psotgres John R Pierce <pierce@hogranch.com>
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:
INSERT INTO mytable(myattr) VALUES('first line
second line
third line');
Regards,
Jeff Davis
В списке pgsql-general по дате отправления
