as of now (October 2024) the right command for the most basic is:

heroku addons:create heroku-postgresql:essential-0

and here as an example is the link for the plans, via the addon page for heroku postgres: heroku postgres add on page