How can I store HTML code in a Postgresql DB table field?

Question

I get a large and vary dynamic XML data feed (200+ categories and 3500+ products that is 11+ MB) to CRUD my DB. The problem is, there is HTML code embedded in the long description field (.e.g. links to a video and player settings as well as page layout. YES, I know, a programming no no - should be done with CSS - but it is there anyhow. When creating the database table HTML is not an option. I am using PHP and PostgreSQL on a WAPP stack. How can I get around this problem?

use TEXT as the column type.

Kenney
– Kenney

2016-01-31 14:29:38 +00:00
Commented Jan 31, 2016 at 14:29 — Kenney
– Kenney, Commented Jan 31, 2016 at 14:29

Robins Tharakan · Accepted Answer · 2016-01-31 18:18:37Z

25

You could try using a TEXT field and dump the HTML there.

Additionally, PostgreSQL has in-built automatic compression for TEXT fields!

answered Jan 31, 2016 at 18:18

Robins Tharakan

2,52122 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I store HTML code in a Postgresql DB table field?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related