Reading from a PostgreSQL Database With Python

With that understanding, we then need to assign values to these variables using the sys module. The sys module has an attribute argv which is an array holding arguments from when the program is executed. By way of example, when one uses the shell command 'mkdir', the name of the directory to be created is the first (and only) argument of the command. If using Python's sys.argv, this argument would be sys.argv[1] -- the name by which the program is executed is always sys.argv[0]. Each additional argument follows in sequence.

Our program will take four arguments, one for each part of the SELECT statement to be made.

table = sys.argv[1]
column = sys.argv[2]
string = sys.argv[3]
operation = sys.argv[4]

Index: Reading from a PostgreSQL Database With Python

1. Introduction
2. Psycopg and Python: Perfect Together
3. Receiving Command Line Arguments for the PostgreSQL Statement - I
4. Receiving Command Line Arguments for the PostgreSQL Statement - II
5. Connecting to PostgreSQL Through Psycopg
6. Forming the PostgreSQL SELECT Statement
7. Executing the SELECT Statement Through Psycopg
8. A Container for the Results
9. Finishing and Executing the Program