Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #417

Re: Line breaks in PostgreSQL tables

Show all headers | View raw

On 10/31/2012 12:12 AM, Franz Kruse 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?

I'd assume that PG happily stores what you insert so it's probably a 
client side issue.  Are you inserting from Windows?

Cheers

	robert

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next 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