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
database encoding. E'\n' is a newline literal (or just '\n' in
Postgres versions prior to 8.1, IIRC). Newline also represents
itself, e.g., '
'.
Michael Glaesemann
grzm seespotcode net