Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #420
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!news.netfront.net!reversiblemaps.ath.cx!not-for-mail |
|---|---|
| From | Jasen Betts <jasen@xnet.co.nz> |
| Newsgroups | comp.databases.postgresql |
| Subject | Re: Line breaks in PostgreSQL tables |
| Date | 1 Nov 2012 08:53:53 GMT |
| Organization | Dis (not Dat) Organisation |
| Lines | 23 |
| Message-ID | <k6tdb1$d54$2@reversiblemaps.ath.cx> (permalink) |
| References | <k6pmsh$qir$1@news.albasani.net> |
| NNTP-Posting-Host | 118.90.24.98 |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=UTF-8 |
| Content-Transfer-Encoding | 8bit |
| X-Trace | adenine.netfront.net 1351760439 36372 118.90.24.98 (1 Nov 2012 09:00:39 GMT) |
| X-Complaints-To | news@netfront.net |
| NNTP-Posting-Date | Thu, 1 Nov 2012 09:00:39 +0000 (UTC) |
| X-Face | ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s;a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ |
| User-Agent | slrn/pre1.0.0-18 (Linux) |
| Xref | csiph.com comp.databases.postgresql:420 |
Show key headers only | 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
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