Error : Laravel 11

[stuckfakur]

SQLSTATE[3F000]: Invalid schema name: 7 ERROR: no schema has been selected to create in at character 14 (Connection: pgsql, SQL: create table "migrations" ("id" serial not null primary key, "migration" varchar(255) not null, "batch" integer not null))

I was input the configuration at env
DB_CONNECTION=pgsql
DATABASE_URL=postgres://postgres.refrence:[email protected]:5432/postgres
DB_PASSWORD=password

and on database.php was change like as a doc

but while i migrate showing error like at above

[arifd11]

In app/config/database.php change
'search_path' => 'laravel' -> 'search_path' => 'public'

[EfrenPech]

Thank you very much it worked

[improved-software]

The public schema is less secure. ❌

Add a laravel schema in the SQL Editor ✔

CREATE SCHEMA laravel