/diet_app

University Project. Diet application in C#

Primary LanguageC#

diet_app

University Project. Diet application in C#

PostgreSQL Database Config.

  1. Create Database:

    CREATE DATABASE dietdb;
  2. Create custom user

    CREATE USER diet;
    GRANT CONNECT ON DATABASE dietdb TO diet;
    GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO diet;
  3. Set Up diet user for dietdb:

    ALTER DATABASE dietdb ONWER TO diet;
  4. Open CMD:

    /* 
     * NOTES:
     *    You must add to the system env. path the path to the psql/bin folder. 
     *    The path must be similar to this: C:\Program Files\PostgreSQL\13\bin 
     */
    ~ psql -U diet dietdb < dietdb.sql