When to use Postgresql array data type

Question

I see that PostgreSQL has an array data type. What is it used for? When is the best situation to use it?

possible duplicate of What are the proper use-cases for the PostgreSQL Array Datatype? — Steve Madsen
– Steve Madsen, Commented Nov 13, 2012 at 19:34

user330315 · Accepted Answer · 2012-09-25 06:24:20Z

2

Defining a column as an array usually means that you have a denormalized model because the content of that array could also be stored as a 1:n relationship.

But the sometimes it makes sense to do so especially if you always treat the "list" as "one thing". It's hard to give concrete examples though. If you can't think of anything, you probably don't need it.

answered Sep 25, 2012 at 6:24

user330315

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

Collectives™ on Stack Overflow

When to use Postgresql array data type

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