create a schme copy of a postgres database (on window)

create_test_db.ps1

set PGPASSWORD="<password>";

pg_dump -d "<database name>" -h "localhost" -p "5432" -U "postgres" --clean --create  --schema-only --file "db_schema_copy" --format custom;

dropdb --if-exists -U postgres "<test database name>";

createdb -U "postgres" "<test database name>";

pg_restore.exe -U postgres -d "<test database name>" .\db_schema_copy;