Groups > comp.databases.postgresql > #420

Re: Line breaks in PostgreSQL tables

From	Jasen Betts <jasen@xnet.co.nz>
Newsgroups	comp.databases.postgresql
Subject	Re: Line breaks in PostgreSQL tables
Date	2012-11-01 08:53 +0000
Organization	Dis (not Dat) Organisation
Message-ID	<k6tdb1$d54$2@reversiblemaps.ath.cx> (permalink)
References	<k6pmsh$qir$1@news.albasani.net>

Show all headers | View raw

On 2012-10-30, Franz Kruse <Franz.Kruse@t-online.de> wrote:
> We just started to use PostgreSQL. For new table entries (type TEXT) we 
> find line breaks represented as \r\n (the Windows convention), wich is 
> OK when shown in a browser, but causes strange multiple empty lines when 
> these entries are sent via email.
>
> Can this behaviour be configured, such that simple \n are used for line 
> breaks?

You get out what you put in.


possibly you could use the repalace function to modify the data or the
result.


OTOH \r\n  should bnot be a problem in emails, all the EMAIL RFCs
require \r\n.

-- 
⚂⚃ 100% natural

--- news://freenews.netfront.net/ - complaints: news@netfront.net ---

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Line breaks in PostgreSQL tables Franz Kruse <Franz.Kruse@t-online.de> - 2012-10-31 00:12 +0100
  Re: Line breaks in PostgreSQL tables Robert Klemme <shortcutter@googlemail.com> - 2012-10-31 19:51 +0100
    Re: Line breaks in PostgreSQL tables Franz Kruse <Franz.Kruse@t-online.de> - 2012-10-31 20:58 +0100
      Re: Line breaks in PostgreSQL tables mattheww@chiark.greenend.org.uk (Matthew Woodcraft) - 2012-10-31 20:39 +0000
      Re: Line breaks in PostgreSQL tables Robert Klemme <shortcutter@googlemail.com> - 2012-11-01 23:37 +0100
  Re: Line breaks in PostgreSQL tables Jasen Betts <jasen@xnet.co.nz> - 2012-11-01 08:53 +0000

csiph-web