Re: Formatting text strings in fields

From: Aarni Ruuhimäki <aarni(at)kymi(dot)com>
To: "Larry J(dot) Gross" <ljgross(at)state(dot)nd(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Formatting text strings in fields
Date: 2004-07-02 16:16:43
Message-ID: 200407021916.43605.aarni@kymi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Larry,

Like Mike said, if you are dealing with html-intputs/outputs, you'll have to
first input something like chr 13+10 into your db for line breaks and for
displaying it nicely out again replace whatever you have with <br> -tags. Or
something similar. With your preferred language's replace functions.

BR,

Aarni

On Monday 28 June 2004 19:39, you wrote:
> Hello:
>
> I am using postgres 7.35 on a Linux 9.0 PC. I am trying to create a
> technical intranet using the postgresql database for the information. When
> I type in a solution to a problem all of the text runs together. An
> example would be:1. Text here 2. Text here 3. Text here.
>
> I would like it to look like the following.
>
> Problem:
>
> Solution:
>
> 1. Text here
> 2. Text here
> 3. Text here
>
> Any help would be appreciated
>
> Thank you
>
> Larry Gross
> Network Specialist II
> MCP, CNE, A+
> ljgross(at)state(dot)nd(dot)us
> (701) 328-5863

--
-------------------------------------------------
This is a bugfree broadcast to you from a linux system.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message R.Welz 2004-07-03 12:51:29 createlang doesn't work
Previous Message Oliver Elphick 2004-07-02 08:47:56 Re: .pgpass