Seeding database error while running locally
Hey y'all, I'm trying to seed my database with some rows from a table called tools from my remote project to my local environment. I think I have the sql queries to insert the data but when I try to execute the seed query I get this error:
This is my seed.sql file, and also I attach the schema for the tools table. (I also tried to copy that data exporting it in csv file but I get kinda the same error, which is weird it's automatically generated by supabase dashboard)
table declaration:
error: malformed array literal "["10 min","30 min"]" (sqlstate 22p02)This is my seed.sql file, and also I attach the schema for the tools table. (I also tried to copy that data exporting it in csv file but I get kinda the same error, which is weird it's automatically generated by supabase dashboard)
table declaration:
CREATE TABLE IF NOT EXISTS "public"."tools" (
"id" bigint NOT NULL,
"name" "text",
"description" "text",
"image_path" "text",
"preparation" "text"[],
"duration" "text"[],
"blog_url" "text",
"author" "uuid",
"created_at" timestamp with time zone DEFAULT "now"() NOT NULL,
"categories" "text"[]
);message.txt8.64KB
