Script to follow along with "Querying JSON Data in PostgreSQL" blog post

create-insert-person.sql

CREATE TABLE public.person
(
    id integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
    personb jsonb NOT NULL,
    person json
)

insert into person (personb, person)
values (
'{"first_name": "Gladys", "last_name": "Perkins", "hobbies": ["Star Gazing", "Coding"]}',
'{"first_name": "Gladys", "last_name": "Perkins", "hobbies": ["Star Gazing", "Coding"]}'
);

insert into person (personb, person)
values (
'{"first_name": "Fran", "last_name": "Allen", "pets": [{"name": "Charlie", "type": "dog"}, {"name": "Marshmallow", "type": "cat"}]}',
'{"first_name": "Fran", "last_name": "Allen", "pets": [{"name": "Charlie", "type": "dog"}, {"name": "Marshmallow", "type": "cat"}]}'
);

It's missing an ; in the end of line 6