Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #417
| Path | csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | Robert Klemme <shortcutter@googlemail.com> |
| Newsgroups | comp.databases.postgresql |
| Subject | Re: Line breaks in PostgreSQL tables |
| Date | Wed, 31 Oct 2012 19:51:48 +0100 |
| Lines | 16 |
| Message-ID | <afdaa5Fh1quU1@mid.individual.net> (permalink) |
| References | <k6pmsh$qir$1@news.albasani.net> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=ISO-8859-15; format=flowed |
| Content-Transfer-Encoding | 7bit |
| X-Trace | individual.net kaTnqXcqBSuvo6pcwWOw4QfA9Zbl9VbM2g86po1N1SN/EYbINhMQqt8V2igCGhasc= |
| Cancel-Lock | sha1:XRMJ9pCaoI4EStG/3qbOaiIOiOE= |
| User-Agent | Mozilla/5.0 (X11; Linux i686; rv:16.0) Gecko/20121011 Thunderbird/16.0.1 |
| In-Reply-To | <k6pmsh$qir$1@news.albasani.net> |
| Xref | csiph.com comp.databases.postgresql:417 |
Show key headers only | 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
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