HTML data type in PostgreSQL

Question

Up to now I use the Character Type "text" to store HTML in PostgreSQL.

I would like to make it more obvious to new users who look at the database schema, that this column contains HTML and not text.

How could I make this more obvious?

PS: I don't want PG to look into the HTML and validate it or quote it. This is just about users looking at the column specification and understanding "aha, this is html, not text".

Tim Biegeleisen · Accepted Answer · 2021-07-08 15:53:59Z

5

Postgres actually does have an XML type, but as HTML is not exactly XML, it may not make sense to use the XML type to store your content.

I suggest just putting the text html into the column name, e.g. something like html_content. This way, it will be very visible to anyone perusing the table about what is contained within this column.

answered Jul 8, 2021 at 15:53

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

HTML data type in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related