Junior — Middle

Have you used ENUM types in PostgreSQL for storing a limited set of values?

sobes.tech AI

Answer from AI

In PostgreSQL, you can create custom ENUM types to store a limited set of values, which helps ensure data integrity and improves schema readability. For example, if you need to store order status, you can define an ENUM with possible values:

CREATE TYPE order_status AS ENUM ('new', 'processing', 'shipped', 'delivered', 'cancelled');

CREATE TABLE orders (
    id SERIAL PRIMARY KEY,
    status order_status NOT NULL
);

This guarantees that only allowed values from the list are stored in the status field. In PHP, when working with such fields, you usually use regular strings, but you can also implement validation or use PHP enums (available in newer PHP versions) to match the database values.

Previous Next