How to define minimum and maximum value as range for a postgresql field?

Question

I would like to compress the values that a field can take in my PostgreSQL database, but could not find a way to do it in a query while creating the table.

For instance, let's say I have a table which is named Books, and it contains some essential information about my books. The fields might be like:

bookId
ownerId
pageNumber

Let's say I want pageNumber field to have a minimum and maximum values as 1 and 500.

Now, it is easy to squeeze the value scale between 1 and 500, but I want to do it on the database side, which needed to be done over postgreSQL query.

Any help would be appreciated.

Thanks in advance.

Gordon Linoff · Accepted Answer · 2020-11-05 11:54:48Z

1

You can add a check constraint:

alter table books add constraint chk_books_pagenumber
    check (pagenumber between 1 and 500);

This limits the values between 1 and 500.

answered Nov 5, 2020 at 11:54

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

How to define minimum and maximum value as range for a postgresql field?

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