PostgreSQL
No edit summary
No edit summary
Line 7: Line 7:
* - Connectionstring takes this form: host=localhost port=5432 dbname=First user=postgres password=xxxxxxx sslmode=prefer connect_timeout=10
* - 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
* - 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:
[[File:MDrPostgreSQL.png|none|thumb|566x566px]]

Revision as of 07:19, 2 October 2023

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:

MDrPostgreSQL.png
This page was edited 4 days ago on 04/29/2024. What links here