Question: how to create a postgresql database in ubuntu?
Answer: Step 1: Login as the Postgres User. su - postgres.
Step 2: Enter the PostgreSQL Environment. psql. With the psql command, you'll be greeted by its current version and command prompt.
Step 3: Creating the PostgreSQL Database. Let's create our first database by typing in the command below.