Query a PostgreSQL database via Python
Posted 11th December 2020
Use this simple template script created in Python to connect to your PostgreSQL database and run a query.
Add a simple search box to a Microsoft Access form
Posted 12th November 2020
A step-by-step guide to adding a simple search box to a Microsoft Access form.
PostgreSQL: Add columns to a query table with variables
Posted 3rd July 2020
Generate a new column in your PostgreSQL database query from data in other columns or other tables.
SQL to CSV via Python, with Headers
Posted 7th June 2019
Nifty Python code that converts a SQL database file into a CSV file and includes column headers.
PostgreSQL: Store a PSQL COUNT query result as a Bash variable
Posted 5th June 2018
Use this nifty code to isolate the result of a PSQL COUNT query as a variable within a Bash script.
Export a PostgreSQL query to a CSV
Posted 24th November 2017
Export the contents of a database table to a CSV file using the psql PostgreSQL utility in PuTTY.
Migrate a local LemnaTec database
Posted 8th June 2016
A step-by-step guide for migrating a local LemnaTec database between network drives.