Documentation:PostgreSQL: Difference between revisions

PostgreSQL

Revision as of 07:15, 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

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

@@ Line 5: / Line 5: @@
 * - C:\Program Files\PostgreSQL\16\ run pg_env.bat
 * - C:\Program Files\PostgreSQL\16\bin>psql.exe dbname=First   (case sensistive)
-* - Connectionstring: 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=123456;Database=First;Include Error Detail=True
+* - Server=localhost;Port=5432;User Id=postgres;Password=<yourpwd>;Database=First;Include Error Detail=True