PostgreSQL does not add braces to text. It sounds like a problem with the code you have that inserts and retreives data
outof PostgreSQL
Let's try a test case:
BEGIN;
CREATE TEMP TABLE test_table (
foo text
);
INSERT INTO test_table (foo) VALUES('<html>foo</html>');
SELECT foo FROM test_table;
ROLLBACK;
The result of the select statement should look like:
foo
------------------
<html>foo</html>
(1 row)
i.e., no added braces.
----
John L. Cheng
________________________________
From: linnewbie <linnewbie@gmail.com>
To: pgsql-general@postgresql.org
Sent: Thursday, April 2, 2009 5:48:40 AM
Subject: [GENERAL] Posgres Adding braces at beginning and end of text (html) content
Hi All,
I'm fairly new to postgres and I'm having this peculiar problem.
I'm storing raw html in a text field and I want users who know HTML to
update the content in a textarea field.
The problem is postgres is adding braces to the begining and ending of
the content. On creation and every time I update.
This is:
I input:
<p>xyz <p/>
..........
into the text area field I save and view I see
{<p>xyz</p>
..........
}
On a subsequent update I see
{{<p>xyz</p>
.........
}}
On another I see
{{<p>xyz</p>
.....
}}
Not sure what is happening here?
I am using postgres 8.3 on windows