CODEWITHSUNDEEP
postgresqlsqldatatypescustom-data-type
ERJAN
ERJAN

Reputation: 24508

what datatype to choose in pgadmin4 to store long text in Postgres instead of 'char varying []'?

I'm storing a title of a post and need to store long text - which is a list of 100 comments for this post. I want to append them altogether and store as a string

in pgadmin4 there is

character varying []

data type available when creating table.

what other options do i have? create my own custom structure?

Upvotes: 0

Views: 2218

Answers (1)

Thirumal
Thirumal

Reputation: 9686

TEXT data type is the best choice and it's a variable with unlimited length

For more information refer https://www.postgresql.org/docs/current/datatype-character.html

Upvotes: 3

Related Questions