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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
