Re: inset html data into text column - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: inset html data into text column
Date
Msg-id 20050419032959.GA75787@winnie.fuhr.org
Whole thread Raw
In response to inset html data into text column  ("rui.justino" <rui.justino@netcabo.pt>)
List pgsql-novice
On Thu, Apr 14, 2005 at 10:28:39AM +0100, rui.justino wrote:
>
> I have a table with a column of type text with no limitation of
> caracters, that i'm trying to insert html formatted text into but
> the text gets truncated.

How are you inserting the HTML?  How are you determining that the
text is truncated?  How many characters are in the truncated text?
Have you used length() to see how much text is in the table?  Is
it possible that all the text is there and the client is truncating
it for output?

> for the moment i have tested with psycopg, pgsql and pgAdmin III.
> always getting the same result.

I don't use pgAdmin but I recall people saying that it truncates
output.  Are you sure the psycopg and psql (? -- you said "pgsql")
tests are correct?  Could you post a simple test case that shows
exactly what you did?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: text parsing function
Next
From: Low Kian Seong
Date:
Subject: How to use the COPY command