=# \d+ reporter.demographic
                           View "reporter.demographic"
      Column      |           Type           | Modifiers | Storage  | Description
------------------+--------------------------+-----------+----------+-------------
 id               | integer                  |           | plain    |
 dob              | timestamp with time zone |           | plain    |
 general_division | text                     |           | extended |
View definition:
 SELECT u.id,
    u.dob,
        CASE
            WHEN u.dob IS NULL THEN 'Adult'::text
            WHEN age(u.dob) > '18 years'::interval THEN 'Adult'::text
            ELSE 'Juvenile'::text
        END AS general_division
   FROM actor.usr u;