Re: Formatting text strings in fields

#1

This actually sounds more like an issue with your html coding. If you
are executing select statements against postgres, a row of data is
returned, are you writing a <br> via perl/php to the screen before the
next row of data is retreived?

If the data returned all in one call then you need to change the way the
data is being saved into postgres. Have the application insert a <br>
after each line before it writes the data into the table.

On Mon, 2004-06-28 at 11:39, Larry J. Gross wrote:

Quote:

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.us

(701) 328-5863

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#2

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:

Quote:

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.us
(701) 328-5863

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Formatting text strings in fields

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: Formatting text strings in fields - 07-01-2004 , 11:19 PM

Re: Formatting text strings in fields - 07-02-2004 , 11:16 AM