but when I run the command:
CREATE TABLE employee_schedule (
id serial,
employee_id integer REFERENCES employees(id),
start_time timestamptz,
end_time timestamptz
);
I get an error message:
NOTICE: CREATE TABLE will create implicit sequence
"employee_schedule_id_seq" for serial column "employee_schedule.id"
ERROR: relation "employees" does not exist
So how can I solve this problem?
You have a foreign key reference (employee_id) to a table (employees) that can't be found in your search_path.
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
