Documentation:PostgreSQL

PostgreSQL

• - Install, remember pwd,
• - C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime>pgAdmin4.exe
  • - register server, localhost:5432
  • - Create Database, First
• - C:\Program Files\PostgreSQL\16\ run pg_env.bat
• - C:\Program Files\PostgreSQL\16\bin>psql.exe dbname=First (case sensistive)
• - Connectionstring takes this form: host=localhost port=5432 dbname=First user=postgres password=xxxxxxx sslmode=prefer connect_timeout=10
• - Server=localhost;Port=5432;User Id=postgres;Password=<yourpwd>;Database=First;Include Error Detail=True

Install an MDrivenServer, and set Connection Type, and connection string: