Error When Migrating Database schema extensions does not exist when migrating database

I have followed the information found here, #1416, and exported from my old database using the command below

pg_dump \
  -h db.thedatabase.supabase.co \
  -U postgres --schema-only \
  --clean --if-exists --schema=public \
  > supabase_schema.sql

pg_dump \
  -h db.thedatabase.supabase.co \
  -U postgres --schema-only \
  --clean --if-exists --schema=public \
  > supabase_schema.sql

pg_dump \
  -h db.thedatabase.supabase.co \
  -U postgres --schema-only \
  --clean --if-exists --schema=public \
  > supabase_schema.sql

pg_dump \
  -h db.thedatabase.supabase.co \
  -U postgres --schema-only \
  --clean --if-exists --schema=public \
  > supabase_schema.sql

when I try to import into my new database, I am getting the error above

psql --dbname "$MAINDB" --single-transaction --variable ON_ERROR_STOP=1 --file supabase_schema.sql

psql --dbname "$MAINDB" --single-transaction --variable ON_ERROR_STOP=1 --file supabase_schema.sql

psql --dbname "$MAINDB" --single-transaction --variable ON_ERROR_STOP=1 --file supabase_schema.sql

psql --dbname "$MAINDB" --single-transaction --variable ON_ERROR_STOP=1 --file supabase_schema.sql

on this statement in the SQL file

    id uuid DEFAULT extensions.uuid_generate_v4() NOT NULL,

id uuid DEFAULT extensions.uuid_generate_v4() NOT NULL,

    id uuid DEFAULT extensions.uuid_generate_v4() NOT NULL,

id uuid DEFAULT extensions.uuid_generate_v4() NOT NULL,

I have been googling around for the last few hours so any help will be appreciated

No replies yetBe the first to reply to this messageJoin