|
Re: Wrapping text: msg#00270db.postgresql.novice
Wim, > I try to store multiple lines in a text field of my database ( a sample > f a logfile). > How do I do this? Now I can only write everything on one line... A postgres text field will accept line breaks with no problem: INSERT INTO some_table ( id, name, comments ) VALUES ( 5, 'Truth', 'Truth needs no favor for her sword Upon the field with Error Nor are her converts ever made By threat of harm or terror' ); However, depending on what tool/langauge you are using to interface with postgresql, this may be more or less difficult. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: User Problem In PostgreSQL on Mac OS X: 00270, David C . Oshel |
|---|---|
| Next by Date: | pq_flush: send() failed: Broken pipe: 00270, Chad Thompson |
| Previous by Thread: | Wrapping texti: 00270, Wim |
| Next by Thread: | pq_flush: send() failed: Broken pipe: 00270, Chad Thompson |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |