Inserting dummy data from seed.sql
I'm using the Supabase CLI, trying to insert some dummy data through seed.sql when local hosting and wondering what I'm doing wrong.
When I run
However if I run the same code in the Supabase SQL Editor with a clean database it runs fine and inserts the dummy data as intended.
If I comment out the "insert into"-line, the table is created and I can later do the insert through the SQL Editor without problems.
What am I doing wrong?
When I run
supabase db reset{"Type":"ErrorResponse","Severity":"ERROR","SeverityUnlocalized":"ERROR","Code":"42P01","Message":"relation \"public.foobar\" does not exist","Detail":"","Hint":"","Position":13,"InternalPosition":0,"InternalQuery":"","Where":"","SchemaName":"","TableName":"","ColumnName":"","DataTypeName":"","ConstraintName":"","File":"parse_relation.c","Line":1360,"Routine":"parserOpenTable","UnknownFields":null}However if I run the same code in the Supabase SQL Editor with a clean database it runs fine and inserts the dummy data as intended.
If I comment out the "insert into"-line, the table is created and I can later do the insert through the SQL Editor without problems.
What am I doing wrong?
