Reading from a PostgreSQL Database With Python

Finally, we should return Python's attention from the main() function and finish off the program.

     return

if __name__ == '__main__':
     main()

As usual, the last loop evaluates the runtime command from the user and passes Python's attention to main().

One can now call the program with the necessary four arguments.

python ./readpostgresql.py cornucopia id > 0

The results are tasty:

(1, 'banana')
(2, 'kiwi')
(3, 'nectarine')

Using this knowledge, you can easily automate access to several PostgreSQL databases and collate the data for any purpose. With my tutorial on inserting data, one can even create new databases "automagically".

Prev

• Introduction
• Psycopg and Python: Perfect Together
• Receiving Command Line Arguments for the PostgreSQL Statement - I
• Receiving Command Line Arguments for the PostgreSQL Statement - II
• Connecting to PostgreSQL Through Psycopg
• Forming the PostgreSQL SELECT Statement
• Executing the SELECT Statement Through Psycopg
• A Container for the Results
• Finishing and Executing the Program

Next