© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
3 replies
Isaac Fimbres

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:
error: malformed array literal "["10 min","30 min"]" (sqlstate 22p02)
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"[]
);
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
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Seeding the database branching
SupabaseSSupabase / help-and-questions
13mo ago
Getting error 413 (file too large) on preview branch while seeding storage
SupabaseSSupabase / help-and-questions
8mo ago
Supabase database not running
SupabaseSSupabase / help-and-questions
3mo ago
Issues with docker running Supabase locally
SupabaseSSupabase / help-and-questions
3y ago