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

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