How can I add postgresql tools to the command line

I am following a tutorial and I am trying to add postresql tools to the terminal, i am having trouble doing that, I have postgreSQL already installed in my laptop

this is the tutorial that I am following https://www.youtube.com/watch?v=I6ypD7qv3Z8 go to minute 12:20 to understadn what I am talking about. I want to have 1_mikroORM-setup in the CMD

thank you

  • To set up a PostgreSQL Media Server database on Windows

    Download and install a PostgreSQL server. For instructions, refer to the PostgreSQL documentation on www.postgresql.org.

    Ensure that the installation includes the PostgreSQL Unicode ODBC driver.
    During installation, set up a user account with superuser privileges.

    Add the PostgreSQL bin directory path to the PATH environmental variable.

    Open the psql command-line tool:

    In the Windows Command Prompt, run the command:

    psql -U userName
    Enter your password when prompted.
    Run a CREATE DATABASE command to create a new database. Specify the following database settings.

    Database name Any name.
    Encoding Must be Unicode–either UTF8 or UCS2.
    Collation Any that is compatible with the encoding.
    Locale Any that is compatible with the encoding.
    For example:

    CREATE DATABASE myDatabase WITH ENCODING 'UTF8' LC_COLLATE='English_United Kingdom' LC_CTYPE='English_United Kingdom';
    Connect to the new database using the command:

    \c databaseName
    Run the postgres.sql script provided in the Media Server installation directory. This script sets up the database schema that Media Server requires. The schema is inserted inside the public schema.

    Micro Focus recommends running the following command to ensure that the script stops running if it encounters an error:

    \set ON_ERROR_STOP on
    Run the script using the command:

    \i 'path/postgres.sql'
    where path is the script file path.

    Grant privileges to the user that Media Server will connect as. If security is not a consideration you could grant all privileges

    Open the Data Sources (ODBC) program:

    In the Windows Control Panel, click System and Security.

    The System and Security window opens.

    Click Administrative Tools.

    The Administrative Tools window opens.

    Double-click Data Sources (ODBC).

    The ODBC Data Source Administrator dialog box opens.

    In the User DSN tab, click Add... .

    The Create New Data Source dialog box opens.

    Select the PostgreSQL Unicode driver from the list and click Finish.

    The PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box opens.

    After these steps, I guess it will be easy for you to proceed.

  • Set Up a PostgreSQL Database on Windows

    • To use Media Server with a PostgreSQL database, you must download and install a PostgreSQL server and ODBC driver, and configure Media Server to connect to the database through the driver.
    • The procedure describes setting up the database server using the psql command-line tool. If you prefer, you can use the pgAdmin graphical user interface. For more information, refer to the pgAdmin documentation on www.pgadmin.org.