PostgreSQL: Check Constraints | Course | 2019

preview_player
Показать описание
PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system widely used to build back end systems. Startups including big companies such as Apple, Cisco, Redhat and more use Postgres to drive their business.

In this video you will learn about check constraints to enforce only valid data to be added to your tables according to check constraints conditions

PS

Thanks for watching…
Рекомендации по теме
Комментарии
Автор

as a person with the gender hello, i feel extremely offended by your video!

saralightbourne
Автор

plz what is wrong here => alter table person add constraint email_check check(email = '%_@_._%');
i'm trying to add a check constraint to verify ifan email is valid

moroccanswag
Автор

I wish we had that constraint in real world too

mahmudhassan
Автор

Its 2024 brother.... I identify myself as hello!

ahammedzulaikh
Автор

The table I created through mockaroo came with 8 genders. Oh boy, this is crazy.

dmarcolinok
Автор

Thank you muslim brother.
when adding constraint for gender I found that we can also do this:
ALTER TABLE person ADD CONSTRAINT gender_constraint
CHECK (gender IN ('Female', 'Male'));

orzumirzayev