Differences

This shows you the differences between two versions of the page.

--- pythonpostgresql [2021/11/29 21:55] – z0hpvk
+++ pythonpostgresql [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 26: / Line 26: @@
 </code>
+=== Example Connection Files ===
+== Using Config Parser ==
 <code python>
 # database.ini
@@ Line 34: / Line 36: @@
 password=pwd
 </code>
 <code python>
 #!/usr/bin/python
@@ Line 66: / Line 67: @@
     print(error)
 </code>
+== Using Credential File ==
+<code python>
+# conndetails.py
+PGHOST="localhost"
+PGDATABASE="doob"
+PGUSER="ian"
+PGPASSWORD="pwd"
+</code>
+<code python>
+import psycopg2
+import conndetails as creds
+conn_string = "host="+ creds.PGHOST +" dbname="+ creds.PGDATABASE +" user="
+               + creds.PGUSER +" password="+ creds.PGPASSWORD
+conn = psycopg2.connect(conn_string)
+cur = conn.cursor()
+query = "select version()"
+cur.execute(query)
+for row in cur:
+  print(row)
+cur.close()
+</code>