First time trying to import a csv file into a postgresql rails database using TablePlus. The table has seven columns but I was only importing a single row with just three of the columns to test it. This was the error I got:
ERROR: null value in column "created_at" of relation "clubs" violates not-null constraint
DETAIL: Failing row contains (58, 702, null, Henderson, NV, null, null, 702example.org, null, null, null, null, null).
INSERT INTO "public"."clubs" ("city", "website", "name") VALUES
('Henderson, NV', '702example.org', '702');
So my question was what does “INSERT INTO “public” mean? I could not find a public table (thinking there was some temporary holding table or something). So does that mean the insert just didn’t happen, or did it go somewhere?
3