Missing Primary Key

[Imran-imtiaz48]

While you define id bigserial (which auto-increments), you do not set it as a primary key. It's best practice to explicitly declare a primary key.

Recommendation:

SQL

CREATE TABLE teachers (
    id bigserial PRIMARY KEY,
    first_name varchar(25),
    last_name varchar(50),
    school varchar(50),
    hire_date date,
    salary numeric
);

[anthonydb]

Hi, yes it is best practice as I cover later in the book. However, as this is a first table I decided not to introduce primary keys just yet as it would require some explanation, and I wanted to instead get to the insert of data and querying quickly.

If we do another edition of the book, I will revisit this.

Thanks.